OraFAQ Forum: Client Tools » Generate DDL from a select

Home » SQL & PL/SQL » Client Tools » Generate DDL from a select (Oracle 11G solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generate DDL from a select [message #459886]

Tue, 08 June 2010 14:27

evoradba
Messages: 136
Registered: April 2005
Location: Canada

Senior Member

Hello
I would like to generate a table & Index ddl using a select statement i did try the following:

select dbms_metadata.get_ddl('TABLE','DEPT','USER') from dual;

However does not provide all the columns in the table only the first one, is there a better way?
thank you
Maria

Report message to a moderator

Re: Generate DDL from a select [message #459887 is a reply to message #459886]

Tue, 08 June 2010 14:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

please use COPY & PASTE so we can see what you do & how Oracle responds

SQL> SET LONG 32000

Report message to a moderator