1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

unable to view DDL script in sqlplus reg

Discussion in 'SQL PL/SQL' started by laxman, Jan 23, 2010.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Hi all,
    i am unable to retreive the whole script in sqlplus,only i am getting the part of the script shown below,also i have tried with SET LINESIZE 2000 but not working.
    .

    regards
    Laxman

    SQL> SELECT dbms_metadata.get_ddl('TABLE','ACC_DET_REF','LAXORA') from dual;

    DBMS_METADATA.GET_DDL('TABLE','ACC_DET_REF','LAXORA')
    --------------------------------------------------------------------------------

    CREATE TABLE "LAXORA"."ACC_DET_REF"
    ( "QRY_ID" NUMBER(10,0) NOT NULL
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    That's because it's a CLOB and is affected by the setting for LONG columns. If you

    set long 50000

    you will see all of the statement.
     
  3. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Thanks a lot sir,it is working now.also thankful for the approach suggest by you related to collection.extremly sorry for replying u lately.

    Regards
    Laxman