set long 1000
set pagesize 0
select DBMS_METADATA.GET_DDL('TABLE','PERSON') from DUAL;