B
Student Database Schema
This appendix lists all the tables from the STUDENT database schema that are used in the book. Each table is listed here with the database table name first; what follows are the columns in that table, an indicator of whether a null value is allowed, the column data type, and a description. The scripts to install this database can be found on the companion website for this book.
Table and Column Descriptions
COURSE: Information for a Course
Column Name |
Null |
Type |
Comments |
|---|---|---|---|
|
|
|
The unique course number |
|
|
|
The full name for this course |
|
|
|
The dollar amount charged for enrollment in this course |
|
|
|
The ID ... |
Get Oracle PL/SQL by Example, 6th Edition 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.
