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 ________ function adds all numbers in a range of cells
A) TOTAL B) SUM C) ADDITION D) ADD
Computer Science & Information Technology
Consider the following information: Computer for Sale: Intel dual-core 2.8GHz processor 4GB DDR2-667MHz dual channel SDRAM 500GB SATA HDD Optical drive If you were to buy another hard drive just like the one listed in the advertisement, which of the steps to allow data to be written to the hard drive would you have to do? (Select all that apply.)
A) Low level format B) Low level partition C) Partition D) High level format E) Convert F) Encrypt
Computer Science & Information Technology