troubleshooting Question
Sql script to spool / save to a disk file (in YYYYMMDD.spl) a select output
I'm no sql scripting person & need an sql script to
print out (ie save to disk file) the list of dormant
users from our Oracle DB for last 30 days:
select * from ACTION_LOG where ACTION_DTTM >= trunc(sysdate-30)
and ACTION_CD in ('SORAS') order by ACTION_DTTM DESC;
Will need someone to prefix it with
set spool .... DormantAccts_YYYYMMDD.spl
to save output to a spool file which we'll email out
print out (ie save to disk file) the list of dormant
users from our Oracle DB for last 30 days:
select * from ACTION_LOG where ACTION_DTTM >= trunc(sysdate-30)
and ACTION_CD in ('SORAS') order by ACTION_DTTM DESC;
Will need someone to prefix it with
set spool .... DormantAccts_YYYYMMDD.spl
to save output to a spool file which we'll email out
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.