SELECT DBMS_METADATA.GET_DDL('TYPES','ZXS_ADD_TYPE','ZXS_TEST') FROM DUAL;
SELECT OWNER,TYPE_NAME,DBMS_METADATA.GET_DDL('TYPES','ZXS_ADD_TYPE','ZXS_TEST') AS TYPE_DDL FROM DBA_TYPES
ORACLE 中存放type的系统表有三个 user_types,all_types,dba_types 其中 user_types中无owner 列
以上在oracle 11g中测试
查看数据库的版本sql
select * from v$version;