Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

10g DDL Reference

Status
Not open for further replies.

Michael42

Programmer
Oct 8, 2001
1,454
US
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".

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top