Oracle’s equivalent for MySQL SHOW CREATE TABLE
SQL> set pages 0
SQL> set long 999999
SQL> select dbms_metadata.get_ddl('TABLE', 'EMPLOYEES', 'EMP') from dual;
SQL> set pages 0
SQL> set long 999999
SQL> select dbms_metadata.get_ddl('TABLE', 'EMPLOYEES', 'EMP') from dual;
Tim replied:
Thanks i dont need an gui for oracle anymore … cheers
May 24, 2009 at 10:55 pm. Permalink.
john replied:
much thanks.
July 14, 2009 at 4:49 pm. Permalink.