This content has been marked as final. Show 5 replies
http://www.lmgtfy.com/?q=google+tutorial1 person found this helpful
If you click on the link that is your name, you'll get a listing of all the posts you've made. Looking very briefly at the questions you've asked, I'm guessing you're talking about Password expiry notification.1 person found this helpful
If you search on UTL_SMTP, you'll find a ton of articles that discuss how to send email from within the database using that package. Such as this askTom question.
1 person found this helpful
KinsaKaUy? wrote:Of course, better than utl_smtp would be utl_mail. It acts as a wrapper around utl_smtp and hides a lot of the ugly details. You'd be very well advised to use utl_mail instead of utl_smtp.
I lost my post again.
I posted few days ago here about....How to send and email or attachement that is and output of a query , like I want to email to DB Admin all users whose password will expire in 7 days.
So the output of this query will be emailed to him:
SELECT username,expiry_date FROM dba_users WHERE expiry_date-sysdate<=7;
But I can not find it anymore :(
I thank you all,
I tried search that previous post of mine because there was a suggested solution on how to email a message that is an output of an sql query. :(