-
Seeing which triggers get executed
Hi all,
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??????????????????
regards
Raj
rajorcl
-
look at user_triggers - table_name and column_name
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|