asked on sqlplus spool file
My Oracle sql script runs fine, but I'd like to add to datetime to the spooled file, is there a way of doing that?
Oracle Database
Last Comment
Roberto Madro R.
ASKER
Yep, it works, but now I'm getting the literal customer ID, "CustomerID12262012", as the name of the spooled file instead of the value of "Customer ID".
Could you please share the code so we can take a look?
ASKER
Due to the nature of the information, I can only attach the script as a picture with some column headers blanked out, no sweat however, you'll get the idea, and as for the "customer ID", it's actually a "Donor ID"
SpoolSQLfileDate.bmp
SpoolSQLfileDate.bmp
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Great job sjwales & many thank
If you need another example, let me know.
https://forums.oracle.com/forums/thread.jspa?threadID=28956