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 Fri May 07 1999 - 05:05:42 CEST