Mastering the Oracle Stack, One Post at a Time.
Practical scripts & utilities
Automation, security scripts, tools, utilities
Wrote a little pl/sql program after several years… glad it worked as expected… thought of sharing the code, might be useful for someone out there… The requirement is to drop tables that are older than 60 days from a schema named CR_BKUP periodically. Did not want to just drop the tables, so taking a backup … Read more
Recently had a request from one of the admins for list of printers used in the EBS application and how many jobs are directed to a printer. The following SQL provided what the admin needed, thought a good one to share… select distinct fcr.printer, fu.user_name, fu.description, count(*) jobs from apps.fnd_concurrent_requests fcr, apps.fnd_user … Read more