Hi all,

In SQL plus, when you use SPOOL option to spool out the output to a file, is it possible for us to have the date concatnate with the file name.

We don't want to hard code the file name and date. what I am trying to do is if I spool this file today it will stamp today date on my file name and let's say tomorrow I run it again it will stamp the date of tomorrow on the file instead of overwriting today's file.

Any advises???
Thanks