1. Write the SQL statement using the NVL function.

2. Write the SQL statement using a Nested Function.

3. Write the SQL statement to convert Characters to Numbers using the TO_NUMBER function.

4. Write the SQL statement to convert Characters to Dates using the TO_DATE function.

5. Write the SQL statement to convert Dates to Characters using the TO_CHAR function

6. Write the SQL statement to convert Numbers to Characters using the TO_CHAR function.

7. Write the SQL statement that integrates an implicit character to Date Conversion.

 

ISBN TITLE PUBDATE 1059831198 BODYBUILD IN 10 MINUTES A DAY 21-JAN-05 0401140733 REVENGE OF MICKEY 14-DEC-05 4981341710 BUILDING A CAR WITH TOOTHPICKS 18-MAR-06 8843172113 DATABASE IMPLEMENTATION 04-JUN-03 3437212490 COOKING WITH MUSHROOMS 3957136468 HOLY GRAIL OF ORACLE 1915762492 HANDCRANKED COMPUTERS 9959789321 E-BUSINESS THE EASY WAY 2491748320 PAINLESS CHILD-REARING 0299282519 THE WOK WAY TO COOK 8117949391 BIG BEAR AND LITTLE DOVE 0132149871 HOW TO GET FASTER PIZZA 9247381001 HOW TO MANAGE THE MANAGER 2147428890 SHORTEST POEMS 28-FEB-04 31-DEC-05 21-JAN-05 01-MAR-06 17-JUL-04 11-SEP-04 08-NOV-05 11-NOV-06 09-MAY-03 01-MAY-05 PUBID COST RETAIL DISCOUNT CATEGORY 4 18.75 30.95 1 14.2 22 2 37.8 59.95 3 55.95 31.4 12.5 4 19.95 75.95 3 47.25 3 21.8 2 25 54.5 89.95 5 4 37.9 48 19 28.75 8.95 29.95 31.95 5 5.32 4 17.85 1 15.4 5 21.85 39.95 (null) FITNESS (null) FAMILY LIFE 3 CHILDREN (null) COMPUTER (null) COOKING 3.8 COMPUTER (null) COMPUTER (null) COMPUTER 4.5 FAMILY LIFE (null) COOKING (null) CHILDREN 1.5 SELF HELP (null) BUSINESS (null) LITERATURE