spool a.dat
select * from emp
spool off
spool b.csv
select empno||';'||ename from emp;
spool off
exit

set term off
set feedback off
set HEADING off 
set pagesize 0
set linesize 120
set verify off
SET echo off
spool /data/dev/ins/dbi/backup/AGENT.dat
SELECT
AGENTKEY || '|' || PERSONID || '|' || ADDRESSID || '|' || AGENCYKEY || '|' || '<END_OF_RECORD>' 
FROM
AGENT;
spool off
/
spool /data/dev/ins/dbi/backup/AGENCY.txt
SELECT
AGENCYKEY || '|' || SNAME || '|' || LNAME || '|' || ADDRESSID || '|' || '<END_OF_RECORD>' 
FROM
AGENCY;
spool off

tmp # touch agent.dat
tmp # ls agent*
agent.dat
tmp # mv agent.dat agent`date '+%Y%m%d'`.dat
tmp # ls agent*
agent20090519.dat
tmp #

select * from emp;
spool off;

select * from emp_det;
spool off;

SQL> col todaydate new_value todaydate
SQL> select to_char(sysdate,'YYYYMMDD') as todaydate from dual;
 
TODAYDAT
--------
20090519
 
1 row selected.
 
SQL> spool EMP_&todaydate..dat
SQL> spool
currently spooling to EMP_20090519.dat