SQL> select dbms_metadata.get_ddl('TABLE','EMP','SCOTT') from dual;DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT')
-------------------------------------------------------------------------------- CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
SQL>表结构中的字段没有显示全,怎么就2个字段,
SQL> desc SCOTT.EMP
名称
---------------------------------------
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
怎么回事???
-------------------------------------------------------------------------------- CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
SQL>表结构中的字段没有显示全,怎么就2个字段,
SQL> desc SCOTT.EMP
名称
---------------------------------------
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
怎么回事???
select to_char(dbms_metadata.get_ddl('TABLE','EMP','SCOTT')) from dual;
set long 10000
如果要导出ddl,最好
set pagesize 0