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