Oracle DBA Interview Question:

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

Submitted by: Administrator

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