Monday, May 24, 2010

how to get table create script in oracle

SQL> SET LONG 9999999
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','TEST') FROM DUAL;

0 comments:

Post a Comment