Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> quick question about after statement triggers
If I have an after statement trigger defined as
cREATE OR REPLACE TRIGGER some_table_aius
after INSERT or update
on some_table
declare
begin
do_some_process( xxx );
end;
and then I do:
insert into some_Table(...)
insert into some_table (...)
update some_table set xxx where yyy
commit;
will the do_some_process function fire twice, once for updates and once for inserts or just once?
thx
jack Received on Mon Oct 17 2005 - 12:54:41 CDT
![]() |
![]() |