Sunday, September 2, 2012

dbms_metadata.get_ddl Not DisPlay full query

SQL> select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;

DBMS_METADATA.GET_DDL('TABLE','DEPT','SCOTT')
--------------------------------------------------------------------------------

CREATE TABLE "SCOTT"."DEPT"
( "DEPTNO" NUMBER(2,0),
"DNAME" VARCHAR2(14

solve::

set heading off;
set echo off;
Set pages 999;
set long 90000;

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;

No comments:

Post a Comment

web stats