通过SQLPLUS方式查看ORACLE的某个表完整的建表语句
set line 200
set pagesize 0
set long 99999
select dbms_metadata.get_ddl('TABLE','TABLE_NAME','TABLE_OWNER') from dual;
示例
set line 200
set pagesize 0
set long 99999
select dbms_metadata.get_ddl('TABLE','table','ORA_WEN') from dual;