This content has been marked as final. Show 5 replies
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.
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.
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 :(