1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. 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!

how to increase width of sql plus output

Discussion in 'SQL PL/SQL' started by imsean, Mar 3, 2009.

  1. imsean

    imsean Active Member

    Messages:
    15
    Likes Received:
    2
    Trophy Points:
    90
    hi guys, i am not used to working with sql plus, but have to on this machine where i can't install anything else. The problem is on SQL Plus the output width seems really less, as a result my rows get broken up and come below one another.

    I went to options, environment and tried adjusting the buffer width but that doesn't seem to change anything, any idea guys?
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Try Using SET LINESIZE for increase the width of SQL PLUS OUTPUT

    Or COLUMN FORMAT for formatting the column especially the size of each column.
     
  3. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    18
    Trophy Points:
    260
    Location:
    India
    hi use

    Code (Text):

    SET NUMWIDTH [I]value[/I] - default width for Number columns
    SET LONG [I]value[/I] - default width for LONG columns
    SET LONGCHUNKSIZE [I]value[/I] - default width for LONG columns
    SET MAXDATA [I]value[/I] - Max width for columns

    [B]SET LINESIZE [I]value[/I] - Width of output[/B]
     
    Cheers! :)

    and