Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
1 day, 21 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
sqlplus spool file
Posted on 2012-12-26
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
6 Comments
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
If you need another example, let me know.
https://forums.oracle.com/forums/thread.jspa?threadID=28956
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".
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
Active 5 days ago
If you want both parameters in the name of the output file, you actually want the spool command to be this:
spool c:\&donor_id&todaysdate
Alternatively, you could also put a period between the parameters (it actually outputs as the same thing - you'd need a double period if you wanted a single period in the file name)
spool c:\&donor_id.&todaysdate
spool c:\&donor_id&todaysdate
Alternatively, you could also put a period between the parameters (it actually outputs as the same thing - you'd need a double period if you wanted a single period in the file name)
spool c:\&donor_id.&todaysdate
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month1 day, 21 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.