Check this link...

http://www.orafaq.com/wiki/Send_mail_from_PL/SQL#Send_mail_with_UTL_SMTP_-_with_attachments

Learn abt UTL_MAIL @ http://www.psoug.org/reference/utl_mail.html

Learn abt UTL_SMTP @ http://www.psoug.org/reference/utl_smtp.html

Hope this helps... 🙂

Yes. You can send mails from oracle database. I think this option available from Oracle 8i. Please refer the link which clearly explains how to send mails from OracleDB.