SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sending Sql Result to email when at least one record found

996398Mar 12 2013 — edited Mar 13 2013

Forum,

This is my first post hope somebody can help me.

I need to have oracle send me email nightly every time this query get at least 1 record, if record is null no email needed.

select name, grade from students
where enrollstatus = -1

(oracle 11g)

I understand that I will need create a schedule task on my server to trigger the script to run on certain time every night.
I have also read about UTL_MAIL function but still have no clue on how sql and utl_mail work together.

Could someone give me some clue ?

Thanks

Way

Edited by: 993395 on Mar 12, 2013 10:13 AM

Edited by: 993395 on Mar 12, 2013 10:14 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2013

Added on Mar 12 2013

#11g, #sql

6 comments

6,618 views