Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Question Unanswered: showing all of a result in sql plus

    IN sql plus you can set the linesize, but if the result exceeds the linesize or of the "screen" it starts to look screwed up. I have a query where the result has like 13 columns and no matter how high I set the linesize it is still scewed up. What can I do so that this query looks okay?
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    set lines 32000
    spool collectresults.lis
    .
    .
    .
    spool off

  3. #3
    Join Date
    Jan 2003
    Posts
    35
    now that is bad ass!

    thanks a lot!!!
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

Posting Permissions

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