如何在SQL * Plus中获取Oracle create table语句

如何在SQL * Plus中获取Oracle create table语句

通过获取表和索引DDL的简单方法：

set heading off;set echo off;Set pages 999;set long 90000;spool ddl_list.sqlselect dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;spool off;