O'Reilly logo

Oracle® SQL by Example, Third Edition by Alice Rischert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required