Show a list of course numbers, their description and their prerequisites. If the prerequisite is null, substitute “None” using NVL and a data conversion function.

What will be an ideal response?


```
SELECT course_no, NVL(TO_CHAR(prerequisite) ,'None')
FROM course
```

Computer Science & Information Technology

You might also like to view...

The four terms that describe the design basis of the Unicode Standard are _____, ________ ,_____ and _________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

In order to view your movie in Windows Media Player, you need to publish it

Indicate whether the statement is true or false

Computer Science & Information Technology

Data ____ allows you to display each field in a database table as an object on a Windows form.

A. binding B. objectification C. reflection D. referral

Computer Science & Information Technology

The expression string2[i] != '\0' becomes nonzero when the end of the string is reached.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology