Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*PLUS simple problem...
Jimmy,
You need to add the following:
set pagesize 0
That should do the trick.
Karl
Jimmy wrote in message <3733029D.22E2BF15_at_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 - 06:20:53 CDT