Oracle sql spool file name

If it is, please let us know via a Comment Comments Comment this solution does not work in all cases Sokrates, June 24, - am UTC. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions Dynamic Spool File Name. Question and Answer. Thanx Fareed. You may create two files on the same day. I thank you very much as it worked like magic HI Tom I apologise for bothering you As the answer you gave me is excellent, it does attach date to the filename, but it also displays it date on the file of which i don't want it to do that, there's already a statement that displays date.. Thanking you in advance December 17, - am UTC. I don't know what you mean.

I think that when he says 'on the file', he means 'in the file'. Zoliswa, December 17, - am UTC. Thanx Zoliswa. A reader, December 17, - am UTC. However filename, extension and separator will take value from table. The problem is that i can't use the values from table.

Could you suggest me a way to do it? Or if i can do this with batch? One way could be creating at runtime a second script, dynamically built based on your query, and then run it to do the job. For example:. How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 5 years, 3 months ago.