-
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
-
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>
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thx, jmodic !!
Yeah, long did the trick - thought it may be serveroutput size which I tried with 1000000 !!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|