Re: Spool Command
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/08/18
Message-ID: <4v62no$325_at_client2.news.psi.net>#1/1
Date: 1996/08/18
Message-ID: <4v62no$325_at_client2.news.psi.net>#1/1
In article <3215DCBF.5D6_at_iag.net>,
"Robert J. McCallister" <rmccalli_at_iag.net> wrote:
>Is [there] a way to concatenate the sysdate with a file name using the
>spool command?
>
>What I am hoping to do have is something like:
>
> filename.081696
>
>Thanks for any assistance.
like this:
col mdy new_v mdy99
select to_char(sysdate,'mmddyy') mdy from dual;
spool filename.&mdy99
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Sun Aug 18 1996 - 00:00:00 CEST