Seeing which triggers get executed
Is it possible to see by anyway, which triggers get executed when a particualr SQL statement is run (the sql statement is successfull)???
Lets say I insert a record into our dear SCOTT's table emp:
Insert into emp (empno, ename.......)
values (123, 'test',....so on);
the statement is successfull. But lets suppose there is a database trigger, which gets fired and puts the name to some 'XXXX' when ever there is a name with 'test'. So instead of going in and checking the record or seeing what triggers are doing what on table emp, can we find what triggers got executed when this particular statement got executed??????????????????
look at user_triggers - table_name and column_name
Click Here to Expand Forum to Full Width