Re: How to spool to file with date in name

On Sun, 05 Sep 2004 04:38:30 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>I'd like to run a SQL from a cron and spool the output to a file with the
>sysdate in the name to make it unique. Someone please tell me how to do
>that.
>

column dt new_value _dt
select to_char(sysdate,'yymmdd') dt
from dual
/
spool file&_dt

--
Sybrand Bakker, Senior Oracle DBA