Oracle DBA Question: Download Oracle DBA PDF

How do I write a cron which will run a SQL query and mail the results to a
group?

Tweet Share WhatsApp

Answer:

Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results through email.

Download Oracle DBA PDF Read All 50 Oracle DBA Questions
Previous QuestionNext Question
what is difference between Co-related sub query and nested sub query?What operator performs pattern matching