Thursday, May 7, 2009

How to find trigger in oracle

You can use the following query to find out triggers for a particular table

select trigger_name from user_triggers where table_name='XXXX';

Use the name of your table instead of XXXX.

No comments:

Post a Comment