SELECT DBMS_METADATA.GET_DDL('<TYPE>','<TABLE>','<SCHEMA>') FROM DUAL