Re: spool file naming

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 17 Nov 1999 05:17:51 +0100
Message-ID: <942812334.18062.0.pluto.d4ee154e@news.demon.nl>

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