Re: dynamic filename creation

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 3 Aug 1999 07:02:18 +0200
Message-ID: <933656537.2709.0.pluto.d4ee154e@news.demon.nl>

column dummy new_value fil
select 'ap'||to_char(sydate,'MMDDYY')||'.txt' dummy from dual;

spool &fil

This should be all.
Never say you can't do it with sql*plus!

Hth,

Sybrand Bakker, Oracle DBA

<HNG_at_SFNA.com> wrote in message news:7o5cq4$g3n$1_at_nnrp1.deja.com...
> Hi,
>
> I'm just trying to create a sqlPLUS procedure to spool output to a
> variable-named PC file (example, apMMDDYY.txt), where MMDDYY is the date
> portion of an input variable).
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 03 1999 - 00:02:18 CDT