Home » SQL & PL/SQL » SQL & PL/SQL » Data Dictionary table for script (DDL) (Oracle 10g)
Data Dictionary table for script (DDL) [message #357952] Fri, 07 November 2008 06:37 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,

Can You please tell me how one can get script(DDL) of a table or any object using data dictionary tables.

I am trying to get the script using sql * plus rather toad or some other tools.

I have tried in "dict" table but dint find it.

Regards,
Pointers.
Re: Data Dictionary table for script (DDL) [message #357953 is a reply to message #357952] Fri, 07 November 2008 06:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search this forum/google/documentation for dbms_metadata.
Numerous examples are available in this forum
Re: Data Dictionary table for script (DDL) [message #357954 is a reply to message #357953] Fri, 07 November 2008 06:48 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

select dbms_metadata.get_ddl('TABLE','BONUS','SCOTT') from dual;
Previous Topic: Row Wise in Column Wise
Next Topic: dbms_job to run for every 30 seconds daily
Goto Forum:
  


Current Time: Fri Dec 09 00:31:22 CST 2016

Total time taken to generate the page: 0.05266 seconds