Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

variable spool file name

433580Apr 5 2006 — edited Apr 5 2006
Good Morning

Can anyone suggest how to include the date into the filename and path
of the spool command.

I have a sheduled process that overrights the spooled output file every time it
runs and I would like to make a new one by making it unique each time


ie)some thing like this
SQL>SPOOL C:\slog_||'(select sysdate from dual)'||.log

thanks


David
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2006
Added on Apr 5 2006
6 comments
3,935 views