how to get ddl

set heading off;

set echo off;

Set pages 999;

set long 10000;

spool ddl_list.sql

select dbms_metadata.get_ddl('TABLE','TABLENAME','USERNAME') from dual;

select dbms_metadata.get_ddl('INDEX','INDEXNAME','USERNAME') from dual;

spool off;