Re: Help with a Script

kjphilbr13_at_aol.com (KJPhilbr13) wrote:

>I want to be able to run a script that creates a Spool file that has
>(Sysdate - 1) in "YYYYMMDD" format in the filename.

set pages 0 feedback off trimspool on
spool spoolon.sql
select 'spool '||to_char(sysdate-1,'yyyymmdd') from dual /
spool off
@spoolon

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!