select dbms_metadata.get_ddl('TABLE','TableName','userName') from dual; select dbms_metadata.get_ddl('PROCEDURE','ProcedureName','userName') from dual;
1, 用PL/SQL 工具导出来啊 2,用如下命令试下看啊:select dbms_metadata.get_ddl('TABLE','TableName','userName') from dual; select dbms_metadata.get_ddl('PROCEDURE','ProcedureName','userName') from dual;
一般都用第3方工具,用pl/sql可以直接生成出来
用pl/sql可以直接生成出来十分方便....
sqlplus 下执行set heading off; set feedback off; spool c:\abc.sql; select dbms_metadata.get_ddl('TABLE','ABC','ZB') from dual; spool off;
select dbms_metadata.get_ddl('TABLE','TableName','userName') from dual;
select dbms_metadata.get_ddl('PROCEDURE','ProcedureName','userName') from dual;
1, 用PL/SQL 工具导出来啊
2,用如下命令试下看啊:select dbms_metadata.get_ddl('TABLE','TableName','userName') from dual;
select dbms_metadata.get_ddl('PROCEDURE','ProcedureName','userName') from dual;
set feedback off;
spool c:\abc.sql;
select dbms_metadata.get_ddl('TABLE','ABC','ZB') from dual;
spool off;
下面有很多选项,选中创表的(create)和includes storage