how to write a database trigger on one of the tables that will email me if anyone added new record on that table ?????

This is exactly the case on http://www.softtreetech.com/dbmail/examples.htm
page. It is similar to SELECT send_main(...) FROM customers.
: Do you have more samples on how to send mail from SQL or PL/SQL ???
: like if I want to send to all customers on email

CREATE OR REPLACE TRIGGER trigger_name AFTER INSERT ON table_name FOR EACH ROW
DECLARE
ret_code NUMBER;
BEGIN
ret_code := send_mail( your_email_address, 'New record inserted',

'Time: ' || SYSTIME || ', User: ' || user, your_email_address );
END;

: how to write a database trigger on one of the tables that will email me if
: anyone added new record on that table ?????