December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP TABLE (Object Syntax)
CREATE Syntax:
CREATE [GLOBAL TEMPORARY] TABLE [schema.]table_nameOF [schema.]object_type( { {column|attribute} [DEFAULTexpr] { SCOPE IS [schema.]scope_table_name] | WITH ROWID | [CONSTRAINTconstraint_name] REFERENCES [schema.]object_table[ON DELETE CASCADE] } | { SCOPE FOR ({column|attribute}) IS [schema.]table_name| REF ({column|attribute}) WITH ROWID | [CONSTRAINTconstraint_name] FOREIGN KEY (column) REFERENCES [schema.]object_table[ON DELETE CASCADE] [Constraint_State_Clause] } ) [OBJECT ID {SYSTEM GENERATED | PRIMARY KEY}] [ON COMMIT {DELETE | PRESERVE} ROWS] [OIDINDEX [indexname] ([physical_attributes_clause] [TABLESPACEtablespace_name])] [Physical_Attributes_Clause] [TABLESPACE_NAMEtablespace_name] [Storage_Clause] [LOGGING | NOLOGGING] [CLUSTER (column[,column...]] [ { ORGANIZATION HEAP [Physical_Attributes_Clause] [TABLESPACEtablespace_name] [Storage_Clause][LOGGING | NOLOGGING] | ORGANIZATION INDEX [PCTTHRESHOLDinteger] [COMPRESSinteger| NOCOMPRESS] [Physical_Attributes_Clause] [TABLESPACEtablespace_name] [Storage_Clause] [LOGGING | NOLOGGING] [[INCLUDINGcolumn] OVERFLOW [Physical_Attributes_Clause] [TABLESPACEtablespace_name] [Storage_Clause] [LOGGING | NOLOGGING]] } [LOB {(lob_item[,lob_item...]) STORE AS (LOB_Parameter_Clause) | (lob_item) STORE AS [(lob_segname)] [(LOB_Parameter_Clause)] ] [VARRAYvarray_itemSTORE AS LOB [lob_segname] [(LOB_Parameter_Clause)]] [NESTED TABLEnested_table ...