Hello,
Though there are ample Oracle 10g docs I was wondering if anyone could recommend a web site that has a text type listing of Oracle 10g DDL\Schema commands simliar to the below. With the Oracle docs these exist but you have to drill down into each command via it's GUI "show text description".
I guess I am looking for a web or pdf quick reference.
This is nice but is Oracle 9i:
Thanks,
Michael42
Though there are ample Oracle 10g docs I was wondering if anyone could recommend a web site that has a text type listing of Oracle 10g DDL\Schema commands simliar to the below. With the Oracle docs these exist but you have to drill down into each command via it's GUI "show text description".
Code:
CREATE [GLOBAL TEMPORARY] TABLE [schema.]table
column datatype [DEFAULT expr] [column_constraint(s)]
[,column datatype [,...]]
table_constraint
table_ref_constraint
[ON COMMIT {DELETE|PRESERVE} ROWS]
storage_options [COMPRESS int|NOCOMPRESS]
[LOB_storage_clause][varray_clause][nested_storage_clause]
Partitioning_clause
[[NO]CACHE] [[NO]ROWDEPENDENCIES] [[NO]MONITORING] [PARALLEL parallel_clause]
[ENABLE enable_clause | DISABLE disable_clause]
{ENABLE|DISABLE} ROW MOVEMENT
[AS subquery]
I guess I am looking for a web or pdf quick reference.
This is nice but is Oracle 9i:
Thanks,
Michael42