You can view the detailed information about triggers in the USER_TRIGGERS view. The information includes the trigger name, trigger type, and the table to which the trigger applies.
Example 1: Query all triggers of the current user and detailed information about each trigger, including the type, status, the table to which the trigger applies, and the owner of the table.
obclient>SELECT TRIGGER_NAME,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OWNER,TABLE_NAME,
STATUS FROM user_triggers;
+----------------+-----------------+------------------+-------------+------------+---------+
| TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | TABLE_OWNER | TABLE_NAME | STATUS |
+----------------+-----------------+------------------+-------------+------------+---------+
| DEL_NEW_REGION | BEFORE EACH ROW | DELETE | SYS | REGIONS | ENABLED |
+----------------+-----------------+------------------+-------------+------------+---------+
1 row in set (0.05 sec)
Example 2: View the definition of the DEL_NEW_REGION trigger.
obclient>SELECT TRIGGER_BODY FROM user_triggers
WHERE TRIGGER_NAME='DEL_NEW_REGION'\G
*************************** 1. row ***************************
TRIGGER_BODY: TRIGGER del_new_region
BEFORE DELETE ON regions
FOR EACH ROW
WHEN (old.region_id >3)
BEGIN
INSERT INTO reg_his(region_id , region_name )
VALUES( :old.region_id, :old.region_name );
END
1 row in set (0.00 sec)