Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*PLUS simple problem...

SQL*PLUS simple problem...

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Fri, 07 May 1999 08:11:25 -0700
Message-ID: <3733029D.22E2BF15@comp.polyu.edu.hk>


Hello all,

    I have a problem about SQL*PLUS.
    I have the following sql file:

    set arraysize 2
    set linesize 100
    set pagesize 100
    set space 0
    set heading off
    set feedback off
    spool aaa.txt
    select * from emp;
    spool off

    The output is stored in aaa.txt. However, I find that there is one blank line at the beginning of aaa.txt. What should I set in SQL*PLUS such that there is no blank line at the beginning of file aaa.txt?

Thanks,
Jimmy Received on Fri May 07 1999 - 10:11:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US