SET NEWPAGE 0 
SET SPACE 2
SET LINESIZE 350
SET PAGESIZE 0
SET ECHO Off
SET FEEDBACK off
set heading on 
set verify off 
spool c:\emp.txt
select empno , ename , deptno 

from emp where 

deptno=&department_number ;
spool off 

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 350
SET PAGESIZE 0
SET ECHO Off
SET FEEDBACK off
set heading off 
spool c:\test1.csv
select 'enumber'||','||'ename'||','||'ejob'||','|| 'edate'
from dual
union all
select eo||','||ena||','||jb||','||hd
from 
(
select
EMPNO  eo,ENAME  ena,JOB   jb,   HIREDATE hd
from emp
where
deptno=&department_no
)
/
spool off 

SQL> set colsep ,
SQL> select sysdate,sysdate from dual;

SYSDATE  ,SYSDATE
---------,---------
29-APR-08,29-APR-08