get ddl by select from oracle

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