Results 1 to 4 of 4

Thread: Output problem

  1. #1
    Join Date
    May 2003
    Posts
    6

    Unanswered: Output problem

    when I use the select statement to display the rows, if the table has too many number of attributes..some attributes do not appear within the vicinity..like I have to drag the scroll bar in the bottom, is there any way to print all the attributes within the boundaries of the SQL window.

    Thank You.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Output problem

    Originally posted by Smoove
    when I use the select statement to display the rows, if the table has too many number of attributes..some attributes do not appear within the vicinity..like I have to drag the scroll bar in the bottom, is there any way to print all the attributes within the boundaries of the SQL window.

    Thank You.
    In SQL Plus? There are various commands to format the output, like:

    COLUMN ename FORMAT A10
    -- that will reduce width of ename to 10 chars

    COLUMN ename NEWLINE
    -- you guessed it!

    Look at the COLUMN and SET commands in the SQL Plus Reference manual for lots more ideas.

  3. #3
    Join Date
    May 2003
    Posts
    87

    Re: Output problem

    You could set the linesize that approx fits the window but then the ouput is all messed up. I personally prefer to scroll the bar in the bottom because I can see the values exact below the column.

    set linesize 80

    Originally posted by Smoove
    when I use the select statement to display the rows, if the table has too many number of attributes..some attributes do not appear within the vicinity..like I have to drag the scroll bar in the bottom, is there any way to print all the attributes within the boundaries of the SQL window.

    Thank You.

  4. #4
    Join Date
    May 2003
    Posts
    6
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •