Datum zum sqlplus spool filename

sqlplus user/password
col spoolname new_value spoolname 

select 'invoice_'||to_char(sysdate, 'yymmdd') spoolname from dual

spool '&spoolname'

select stuff . . . .
spool off

MadWiki: OracleTipps/DateInSpoolFileName (last edited 2014-02-06 08:15:43 by HannesThiemann)