Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*PLUS simple problem...
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