You may also want to check out the 9i supplied package dbms_metadata. It can generate DDL for any database object.
> -----Original Message----- > From: Andy Hassall [mailto:[EMAIL PROTECTED] > Sent: Friday, 30 January 2004 11:26 AM > To: Rice, Wayne R (Sybase); [EMAIL PROTECTED] > Subject: Re: How-To generate DDL for Oracle tables using Perl? > > > 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/a96 612/d_metad2.htm#1024701 -- Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
