how to increase width of sql plus output

in Oracle Database; hi guys, i am not used to working with sql plus, but have to on this machine where i can't ...
+ Post Reply + Post New Topic
Results 1 to 3 of 3
  1. #1
    imsean is offline Junior Member
    Points: 310, Level: 6
    Join Date
    02 Jan 2009
    Posts
    15
    Points
    310

    how to increase width of sql plus output

    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. #2
    rajavu's Avatar
    rajavu is offline Forum Guru
    Points: 10,830, Level: 68
    Join Date
    13 Oct 2008
    Location
    @ Bangalore , India
    Posts
    815
    Points
    10,830

    Re: how to increase width of sql plus output

    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.

    Raj.
    jirka says Thanks.

  3. #3
    tyro's Avatar
    tyro is offline Forum Genius
    Points: 5,680, Level: 48
    Join Date
    20 Aug 2008
    Location
    India
    Posts
    368
    Points
    5,680

    Re: how to increase width of sql plus output

    hi use

    Code :
    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

Other Solutions
  1. How to increase length of Metadata field.
    By Rahul vaid in forum Oracle Webcenter Suite (formerly Oracle ECM)
    Replies: 2
    Last Post: 04-15-2011, 03:45 AM
  2. How to increase speed of procedure?
    By awdigrigoli in forum SQL PL/SQL
    Replies: 2
    Last Post: 02-16-2011, 02:57 PM
  3. Increase QuickSearch returned records
    By vibecy in forum Oracle Webcenter Suite (formerly Oracle ECM)
    Replies: 0
    Last Post: 06-02-2010, 11:15 AM
  4. Increase right side margin in report builder
    By jacob_joseph in forum Oracle Database
    Replies: 6
    Last Post: 11-26-2009, 03:19 AM
  5. Please increase the session time
    By rajavu in forum Site Announcements and Feedback
    Replies: 3
    Last Post: 10-17-2008, 11:30 AM