Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>