Creating Regular and Temporary Tables
The CREATE TABLE command is used to create relational or object tables. Relational tables are the basic structure used to hold user data. Object tables are used to hold tables that have an object type for a column definition. Object tables are explicitly defined to hold object instances of a particular type (but we will not cover object tables for this exam).
Oracle suggests, rightfully, that locally managed tablespaces are best for table creation because they help to avoid fragmentation.
The following is an example of a CREATE TABLE script:
CREATE TABLE friends( Fname varchar2(35), Lname varchar2(35), Birthday date, Email_address varchar2(100), Street_addr1 varchar2(100), Street_addr2 varchar2(100), Street_addr3 ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.
