Sysdate in Filename for spool Command

[Thomas Kindermann]

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

[mcstock]

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@gmx.de> wrote in message
news:3fab6530$0$41436$45beb828@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

[Daniel Morgan]

Thomas Kindermann wrote:
Hi,another question, i hope it is the last:How can i use the spool command with the sysdate function ?ThanksThomas KindermannOracle Admin
Making a wild stab at what you are asking as your question is very
ambiguous and you
have not included any version information.

SELECT TO_CHAR(SYSDATE, 'MM/DD/YYYY')
FROM some_table;

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Dave]

mcstock wrote: 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@gmx.de> wrote in message news:3fab6530$0$41436$45beb828@newscene.com...Hi,another question, i hope it is the last:How can i use the spool command with the sysdate function ?

Working code for his explanation ...


column spool_date new_value spool_date

select to_char(sysdate, 'dd-mon-yyyy') spool_date
from dual
/

spool my_file_&&spool_date..txt


--
Richard Kuhler