Hi,

I want to spool a query result without heading, title and the blank line in a text file, but no matter what I tried,use "space 0, newspace 0", there is alwasy a blank line between the content and the top border in the spool file, can anyone have good idea to get rid of it?
Thank you!

What I wrote -
"set heading off;
set space 0;
spool result.txt;
select id, name from emp;
spool off;
set space 1;
set heading on;
"

-Betty