sqlplus中利用spool生成帶日期的檔名

sqlplus中利用spool生成帶日期的檔名
col spf new_value spf noprint
select 'd:'||to_char(sysdate,'yyyymmdd')||'.txt' spf from dual;
spo &spf
select * from dual;
spo off;[@more@]

--sqlplus中利用spool生成帶日期的檔名
accept un prompt '使用者名稱：'
accept pw prompt '密 碼：' hide
accept db prompt '資料庫：'
connect ;
pause 繼續嗎？

set feedback off
set pages 0
set lines 30000
set trims on
set trim on
set ver off
set heading off
set time off
set timing off
set autot off
set echo off
set show off
set term off

col spf new_value spf noprint
select 'd:'||to_char(sysdate,'yyyymmdd')||'.txt' spf from dual;
spo &spf
select * from dual;
spo off;
exit