[get_ddl]
select DBMS_METADATA.GET_DDL(object_type, object_name) from user_objects where object_type = 'TABLE' and object_name = 'MY_TABLE'
select dbms_metadata.get_ddl('TABLE','SALES', 'SCOTT') from dual;
select dbms_metadata.get_ddl('TABLESPACE','TBS_NAME') from dual;
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
FROM USER_TABLES u;
[oracle, java data type mapping]
https://docs.oracle.com/cd/B19306_01/java.102/b14188/datamap.htm
