Appendix F. Additional Example Tables
Throughout this book, some exercises make use of tables that are not part of the STUDENT schema diagram listed in Appendix D, “STUDENT Database Schema.” You can create these additional tables in your STUDENT schema by downloading the script sql_book_add_tables.sql from the companion Web site, located at www.oraclesqlbyexample.com. The purpose of these additional tables is to illustrate SQL concepts that could otherwise not be shown within the available data and data types in the STUDENT schema.
Chapter 4: Character, Number, and Miscellaneous Functions
GRADE_SUMMARY: Shows the use of the COALESCE function
FLOAT_TEST: Helps demonstrate the use of the BINARY_FLOAT data type
Chapter 5: Date and Conversion ...
Get Oracle SQL By Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
