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 :(