SELECT to_char(DBMS_METADATA.GET_DDL(OBJECT_TYPE, object_name)) FROM all_OBJECTS where OBJECT_TYPE = 'TABLE' and owner = 'owner' and object_name = 'table_name';
SELECT to_char(DBMS_METADATA.GET_DDL(OBJECT_TYPE, object_name)) FROM all_OBJECTS where OBJECT_TYPE = 'TABLE' and owner = 'owner' and object_name = 'table_name';