DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL* environment setting

  1. #1
    Join Date
    May 2002
    Posts
    35

    SQL* environment setting

    Hi, all

    I have got a problem with my SQL* 8.1.7 setting. When I select more than 1 columns from any table, if I set wrap environment to ON, all the rows will be displayed in one column, looks like this:

    TABLE_NAME
    ------------------
    COLUMN_NAME
    ------------------
    CONSTRAINT_NAME
    ------------------
    CBU_AD_USER
    V_USER_ID
    SYS_C00917

    CBU_AD_USER
    V_USER_NAME
    SYS_C00918

    CBU_AD_USER
    V_PASSWORD
    SYS_C00919

    If I set wrap off, then only the first column is displayed always. Is there something wrong with my SQL* setting? Thank you.

  2. #2
    Join Date
    May 2002
    Posts
    35
    Hi, all

    I have found the reason. It's because the column size of this column_name is 4000! This table is created by oracle (8.1.7), I don't know why it's so big. Anyhow I can configure the format by COLUMN column_name format a20 to limit the displaying width.

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