Appendix E. Table and Column Descriptions

Table . COURSE: Information for a course

Column Name

Null

Type

Comments

COURSE_NO

NOT NULL

NUMBER(8, 0)

The unique ID for a course.

DESCRIPTION

NULL

VARCHAR2(50)

The full name for this course.

COST

NULL

NUMBER(9,2)

The dollar amount charged for enrollment in this course.

PREREQUISITE

NULL

NUMBER(8, 0)

The ID number of the course which must be taken as a prerequisite to this course.

CREATED_BY

NOT NULL

VARCHAR2(30)

Audit column—indicates user who inserted data.

CREATED_DATE

NOT NULL

DATE

Audit column—indicates date of insert.

MODIFIED_BY

NOT NULL

VARCHAR2(30)

Audit column—indicates who made last update.

MODIFIED_DATE

NOT NULL

DATE

Audit column—date of last update.

Table . SECTION: Information for an individual section (class) of a particular ...

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.