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!

spooling with dynamic file names

612530Jan 30 2008 — edited Jan 30 2008

Hi
i'm having a situation where i need to execute a script daily, the logs of the script should be saved using spool. is there a way to dynamically create a destination file with the filename as "spooled_text_"||sysdate

like

spool spooled_text_30_Jan_2008_08_45_AM

Any help is greatly appreicated

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2008

Added on Jan 30 2008

4 comments

299 views