Get DDL

set long 100000

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

(c) https://stackoverflow.com/questions/26249892/how-can-i-generate-or-get-a-ddl-script-on-an-existing-table-in-oracle-i-have