4.2. Table Descriptions

The following includes the table descriptions for the data model.

 SQL> desc state_lookup Name Null? Type ------------------------------- -------- ----------- STATE NOT NULL VARCHAR2(2) STATE_DESC NOT NULL VARCHAR2(30) SQL> desc major_lookup Name Null? Type ------------------------------- -------- ----------- MAJOR NOT NULL VARCHAR2(2) MAJOR_DESC NOT NULL VARCHAR2(15) SQL> desc students Name Null? Type ------------------------------- -------- ----------- STUDENT_ID NOT NULL VARCHAR2(10) STUDENT_NAME NOT NULL VARCHAR2(30) COLLEGE_MAJOR NOT NULL VARCHAR2(2) STATUS NOT NULL VARCHAR2(15) STATE VARCHAR2(2) LICENSE_NO VARCHAR2(30) SQL> desc student_vehicles Name Null? Type ------------------------------- -------- ----------- ...

Get Programming Oracle® Triggers and Stored Procedures, Third 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.