Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: spool file naming
Generally
column timest new_value _dt
select to_char(sysdate,'yyyymmdd') timest
from dual;
define filnam = 'c:\myfolder\file_&_dt..log'
etc.
Hth,
--
Sybrand Bakker, Oracle DBA
<kal121_at_yahoo.com> wrote in message news:80skjo$mdb$1_at_nnrp1.deja.com...
> Is there an easy way to append the sysdate to the spool file name?
>
> SPOOL c:\myfolder\file||SYSDATE||.log -- sort of like this?
>
>
> Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 22:17:51 CST