RE: create trigger after insert

[Suhen Pather]

THANKS,               I resolved the issue.             If I use a script like the one below to test the trigger "for each row" and "statement insert"  it is taken as multiple statements.                         It works fine now               Regards             Suhen               List,   I am creating a trigger that should fire when records are inserted into a table TEST and should send an email via utl_smtp.  The mailing is working fine.   I am trying to get the trigger to fire after a group insert statement rather than each time a record is inserted. I have not included the "for each row" syntax but it still fires after each row is inserted.   Will the entry below be regarded as one insert statement if I put into a sql script and execute via sqlplus.   insert into test values ('Suhen'); insert into test values ('Suhen'); insert into test values ('Suhen'); insert into test values ('Suhen');       My create trigger syntax used:   create or replace trigger test_trigger after insert on test begin send_mail ('Suhen','[EMAIL PROTECTED]','Insert','Records inserted into test'); end; /   I am busy looking through the docs for more info.   Any help would be greatly appreciated.   Regards Suhen