| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Emailing Query Results?
I would like to create a query that runs nightly (maybe a procedure, kicked
off from oracle jobs?) that runs a query, and if the query results in rows
returned, then to have it email to a specified email account(s). Think
exception list - for example, select customer_no, customer_name, city, state
from customers where customer_zip_code is null or length(customer_zip_code)
not in (5,10); - This way we can tackle nightly issues that arrise before
they become a large issue. (I KNOW I KNOW - require the field - Our
specific example isn't based on ZIP CODE, so I can't for other reasons)
Has anyone done this? Can anyone give me examples?
Thanks,
M
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 27 2004 - 10:08:06 CDT
 |
 |