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 -> Re: SQL*PLUS simple problem...

Re: SQL*PLUS simple problem...

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Fri, 07 May 1999 11:05:42 +0800
Message-ID: <37325885.A4C64519@ccis.adisys.com.au>


If you set pagesize 0 then you will not get the blank line. You can also remove 'set heading off' because the heading is not printed if you set the pagesize to 0.

Geoff

Jimmy wrote:

> 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 Thu May 06 1999 - 22:05:42 CDT

Original text of this message

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