Sqlplus Display Help !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Sqlplus Display Help !!

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    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


  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #3
    Join Date
    Jul 2003
    Posts
    323

    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
  •  



Click Here to Expand Forum to Full Width