Re: using SPOOL in sqlplus

From: Mike Dwyer <dwyermj_at_co>
Date: Wed, 4 Oct 2000 15:47:18 -0600
Message-ID: <5FNC5.2$9j1.273@wdc-read-01.qwest.net>

column sdate new_value sdate
select 'f' || to_char( sysdate, 'yymmddhhmiss') || '.lst' sdate from dual; spool &sdate

You may also want to "set termout off" before the select, and "set termout on" afterwards.

<froliol_at_my-deja.com> wrote in message news:8rdeq3$c92$1_at_nnrp1.deja.com...
> Greetings All, I want to be able to create a dynamic output file name
> based on current date and time. Using spool I cannot seem to pass a
> name for an output file, I can only explicitly state it? Has anyone
> ever passed a variable name to spool as the output file?
>
> Any help would be greatly appreciated.
>
> L
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 04 2000 - 16:47:18 CDT