Extract DDL of Table

 Using metadata package DBMS_METADATA to extract DDL of the table 

SQL> set long 9000

SQL> select dbms_metadata.get_ddl ('TABLE','EMP_INFO') from dual;

--Nikhil Tatineni--

--Database --