Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Unanswered: set sqlblanklines or spool help

    is there a "set sqlblanklines on" equivalent in oracle 7?



    if there isn't, i'm trying to run this script

    set feedback off
    set verify off
    set heading off
    spool test.txt
    select count(*) from dual;
    spool off

    and test.txt has a blank line then the result sfrom the select statement. Is there a way to not get the blank line?

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    I think you are looking for:

    SET NEWPAGE 0

    Not 100% sure of this. In 9i, the command SET NEWPAGE NONE works like you need. Format for 7 is SET NEWPAGE n, which I think it will accept a 0.

    JoeB

Posting Permissions

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