Re: Sysdate in Filename for spool Command

[Quoted] there is no inherent relationship between the two, and it's not at all clear what you're asking -- but i'll take a stab at it anyway ;-)

if you mean you'd like to include the current date and/or time in the spool filename, then look into using the COLUMN xxx NEW_VALUE, which populates a SQL*Plus substitution ('define') variable based on the value of a column in a SELECT statement -- the variable can then be used with the SPOOL command

"Thomas Kindermann" <tkinder_at_gmx.de> wrote in message news:3fab6530$0$41436$45beb828_at_newscene.com...
> Hi,
> another question, i hope it is the last:
>
> How can i use the spool command with the sysdate function ?
>
> Thanks
>
> Thomas Kindermann
> Oracle Admin
>
>
Received on Fri Nov 07 2003 - 13:00:02 CET