1. Write the SQL statement that integrates an implicit character to Date Conversion.
2. Write the SQL statemen to convert Numbers to Characters using the TO_CHAR function.
3. Write the SQL statement to convert Dates to Characters using the TO_CHAR function.
4. Write the SQL statement to convert Characters to Dates using the TO_DATE function.
5. Write the SQL statement to converting Characters to Numbers using the TO_NUMBER function.
6. Write the SQL statement using a Nested Function.
7. Write the SQL statement using the NVL funciton.
8.  

Transcribed Image Text:

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

Solution 1 SQL statement with an implicit charactertodate conversion SEL... View the full answer