5 Replies Latest reply: Dec 14, 2012 4:13 AM by 846231 RSS

    UTL_SMTP Mail

      Hi all,

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