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?
What I wrote -
"set heading off;
set space 0;
select id, name from emp;
set space 1;
set heading on;
REPH LEFT '1' report_date 'XXXN'
REPF LEFT '9'report_date1
I am getting 2 blank space adove the '120120922XXXN' header line.I dont want 2 blank space at the strating of the file.And I want to return in footer '900000000' total record count.
EG:My output has 8 line excluding header footer.So i want to return like ''900000008'