Steve Baldwin wrote: > >> -----Original Message----- >> From: Andy Hassall [mailto:[EMAIL PROTECTED] >> >> Rice, Wayne R (Sybase) wrote: >>> I wish to generate DDL for an Oracle 9i table. Does anyone >>> know how to do this? Examples are appreciated... >> >> The DDL for an existing table? >> >> See: >> http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_metad2.htm#1024701 >>
> You may also want to check out the 9i supplied package dbms_metadata. > It can generate DDL for any database object. Actually that link above goes to the DBMS_METADATA documentation... ;-) -- Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
