Skip to Main Content
Forums

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!

how to view all table scripts in sql*plus?

VPSOct 31 2006 — edited Nov 27 2006
Friends,

To view a single table script we can use the below query
select dbms_metadata.get_ddl('TABLE','EMP','SCOTT') from dual;

but i want to view all the tablescript created by scott .
how can i write a query?

thanks
sathyguy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2006
Added on Oct 31 2006
15 comments
2,180 views