Oracle DBA Question:
Download Questions PDF

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

Answer:

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

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
what is difference between Co-related sub query and nested sub query?What operator performs pattern matching