Query user_triggers : user_triggers « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. user_triggers

Query user_triggers

   
SQL>
SQL>
SQL> select trigger_name, trigger_type,
  2       triggering_event, trigger_body
  3  from user_triggers
  4  where rownum < 50;

TRIGGER_NAME                   TRIGGER_TYPE
------------------------------ ----------------
TRIGGERING_EVENT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TRIGGER_BODY
--------------------------------------------------------------------------------
AW_DROP_TRG                    AFTER EVENT
DROP
BEGIN
  aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner);


SQL>








Related examples in the same category

1.Query user_triggers with trigger name
2.Restore trigger create statement from user_trigger table
3.If trigger exists, drop trigger
4.Check the status of the trigger