-
Sqlplus Display Help !!
I am running
SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;
and get to see only partial output on screen like :
DBMS_METADATA.GET_DDL('TABLE','EMP')
----------------------------------------
CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
SQL>
I did get the whole output once but since then it's been like shown above which I find weird!
Any ideas on how to make the whole thing appear, some variables I've tried to set are:
set pagesize 100 (& 500) - no change to the above output !!
set arraysize 100
set feedback off
:confused:
-
Your SQL*PLus environment variable LONG is set to low (probably to 80, which is the default), so you get all your long columns truncated to that setted value. Set it to something greater to see the whole contents of a long columns, like:
SQL> set long 2000000000
SQL>
-
Thx, jmodic !!
Yeah, long did the trick - thought it may be serveroutput size which I tried with 1000000 !!
:p
