Prerequisites: Requirements using SQL Plus.
SQL> SET PAGES 0
SQL> SET Long 1000000
SQL> SELECT DBMS_METADATA.GET_DDL ('Table', 'Name ",' User Name ') from DUAL
