Appendix F. Additional Example Tables

Throughout this book some exercises made use of tables not part of the STUDENT schema diagram listed in Appendix D, “STUDENT Schema Diagram.” These additional tables can be created in your STUDENT schema by downloading the script sql_book_add_tables.sql from the companion Web site located at: http://authors.phptr.com/rischert3e. The purpose of these additional tables is to illustrate SQL concepts that could otherwise not be shown within the available data and datatypes in the STUDENT schema.

Table And Column Descriptions

Chapter 3: Character, Number, And Miscellaneous Functions

Table . GRADE_SUMMARY: Shows the use of the COALESCE function

Column Name

Null

Type

Comments

STUDENT_ID

NULL

NUMBER(8,0)

The unique ID for a ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.