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...
Which of the following is not a type of iteration statement in Java?
a. while statement. b. do…while statement. c. for statement. d. loop statement.
Computer Science & Information Technology
The bulleted list and the outline features in Word function the same when opened in PowerPoint
Indicate whether the statement is true or false
Computer Science & Information Technology
The ________ function counts the number of cells in a range that meet a certain criteria
Fill in the blank(s) with correct word
Computer Science & Information Technology
The frameborder attribute of the tag turns frame orders on or off (with a value of "on" or "off").
Answer the following statement true (T) or false (F)
Computer Science & Information Technology