Avatar of Roberto Madro R.
Roberto Madro R.
Flag for United States of America 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

Avatar of undefined
Last Comment
Roberto Madro R.

8/22/2022 - Mon
ajexpert

I guess this link has anwer to your question.

If you need another example, let me know.

https://forums.oracle.com/forums/thread.jspa?threadID=28956
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".
ajexpert

Could you please share the code so we can take a look?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Roberto Madro R.

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
ASKER CERTIFIED SOLUTION
Steve Wales

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Roberto Madro R.

ASKER
Great job sjwales & many thank