Wednesday, February 2, 2011

Find a table's metadata without using Toad

Simply use this dynamic SQL:

select dbms_metadata.get_ddl('TABLE','tablename','username') from dual;

No comments:

Post a Comment