Results 1 to 7 of 7

Thread: Stuck?

  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: Stuck?

    I'm probably being blind/dumb but i can't work/find out how to turn off the column name headers in sql*plus.

    i.e.
    Code:
    x          y
    --------  -------------
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
                                    don't want these 
    x          y                  or this line 
    --------  -------------    or this 
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    fsdgsd    wergwegw
    Any ideas?
    Last edited by rhs98; 03-05-02 at 07:47.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    set pagesize 0

    That will do it
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    cool. thanks alot it does the job nicely

  4. #4
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    oh yeah; you got any idea how to set the output wrapping witdh (or idealy turn it off)...?

  5. #5
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    set hea off

  6. #6
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Question

    how do you turn the screen output off but keep the spooling? --> i wanna make a csv file with lots of records...will be faster with the screen output off yes?

  7. #7
    Join Date
    Mar 2002
    Posts
    1
    use the sql plus command
    set header off

    Jawahar

Posting Permissions

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