Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: some environmental variable in SQL*Plus

    Dear experts,

    I need to spool rows from a select statement to a text file.

    What parameters in SQL*PLUS should I set if I

    1) do not want to see the sql> prompts in the text file

    sql> select col1, col2 from table1;

    col1, col2
    col1, col2

    sql> spool off

    2) set heading off, I get an extra line as the first line in my text file. How do I get rid of the extra line?

    Any advice greatly appreciated.



  2. #2
    Join Date
    Nov 2002
    try feedback off as well and you will see the net data only

Posting Permissions

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