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.

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Assuming that the table name is Books 1 Using NVL function SELECT NVLDISCOUNTNA AS DISCOUNT FROM boo... View the full answer