Home » Infrastructure » Windows » spool file to file with the date as suffix (oracle 10g, windows XP)
spool file to file with the date as suffix [message #335267] Mon, 21 July 2008 12:13 Go to next message
eagyeman
Messages: 6
Registered: May 2007
Junior Member
I am creating a batch script in windows (DOS). The script is to spool the results of a query to a file named (for example)test_07212008_14:10:56.

Where 07212008 is the date the script will run and 14:10:56 is the time in HR24:MI:SS format.

I am a unix guy and this DOS thing is killing me. Any ideas as to how I can do this in windows.

Re: spool file to file with the date as suffix [message #335277 is a reply to message #335267] Mon, 21 July 2008 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64101
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why if you post a Windows question did you post this in Unix forum and Windows one?
If you had a look at Windows forum, you'd find answer to this question already asked several times.

Regards
Michel
Re: spool file to file with the date as suffix [message #335294 is a reply to message #335267] Mon, 21 July 2008 14:03 Go to previous message
eagyeman
Messages: 6
Registered: May 2007
Junior Member
Thanks for all your help I have found a way to do it

Previous Topic: oracle sqlplus error ora-24324 and ora-01041?
Next Topic: problem with batch file while scheduling RMAN backup (2 threads merged by bb)
Goto Forum:
  


Current Time: Fri Dec 02 13:47:41 CST 2016

Total time taken to generate the page: 0.10719 seconds