spool file without blank line

[Betty]

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

[pando]

set pagesize 0
set trimspool on

[Betty]

Great !
Thank you! It works!

[gobi]

I am using below code:

SET FEEDBACK OFF
SET NEWPAGE NONE
set trimspool on
SET ECHO OFF
SET HEADING OFF
set verify off
set feed off
SET LINESIZE 140

COLUMN file_name NOPRINT new_value l_file_name
SELECT 'CONCUR' || to_char(sysdate + 7,'yyyymmdd') file_name from dual;

spool D:\HoneywellInterfaces\Canada_Payroll\&l_file_name..txt

COLUMN current_date NOPRINT NEW_VALUE report_date
SELECT TO_CHAR(SYSDATE + 7,'YYYYMMDD') current_date FROM DUAL;

COLUMN current_date1 NOPRINT NEW_VALUE report_date1
SELECT TO_CHAR(0, 'FM00000000') current_date1 FROM DUAL;


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'

Please help me in these 2 issues.

My Output is:



120120922XXXN
2C04799 0000000 EXP 000000 0000004500 Expense Reimbursement-No Tax
2C07399 0000000 EXP 000000 0000026707 Expense Reimbursement-No Tax
2C00777 0000000 EXP 000000 0000004264 Expense Reimbursement-No Tax
2C02491 0000000 EXP 000000 0000051888 Expense Reimbursement-No Tax
2C01600 0000000 EXP 000000 0000024440 Expense Reimbursement-No Tax
2C24912 0000000 EXP 000000 0000032571 Expense Reimbursement-No Tax
2C02449 0000000 EXP 000000 0000099980 Expense Reimbursement-No Tax
2C28054 0000000 EXP 000000 0000024544 Expense Reimbursement-No Tax
900000000