DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Seeing which triggers get executed

  1. #1
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
  •  


Click Here to Expand Forum to Full Width