SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export DDL scripts from toad to sql file using stored procedure

2813225Jan 6 2015 — edited Jan 7 2015

Hi,

I can see table structures in toad using create_scripts option. But i have an requirement that using procedure i need to export the same DDL scripts into .sql file. I know one functionality which retrieves the DDL scripts as follows:

Select dbms_metadat.get_ddl('TABLE','TABLE_NAME') from dual.

The above query will give output in CLOB datatype which i cannot export into .sql file.

Can anyone help me in this?

Regards,

Nagalakshmi

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2015

Added on Jan 6 2015

12 comments

5,079 views