ALL_TRIGGERS

obclient[SYS]> SELECT * FROM SYS.ALL_TRIGGERS\G

*************************** 1. row ***************************
            OWNER: SYS
     TRIGGER_NAME: ORDER_LIST_INSERT
     TRIGGER_TYPE: INSTEAD OF
 TRIGGERING_EVENT: INSERT
      TABLE_OWNER: SYS
 BASE_OBJECT_TYPE: VIEW
       TABLE_NAME: ORDER_LIST
      COLUMN_NAME: NULL
REFERENCING_NAMES: REFERENCING NEW AS NEW OLD AS OLD
      WHEN_CLAUSE: NULL
           STATUS: ENABLED
      DESCRIPTION: NULL
      ACTION_TYPE: PL/SQL
     TRIGGER_BODY: TRIGGER order_list_insert
     INSTEAD OF INSERT ON order_list
     DECLARE
       duplicate_info EXCEPTION;
       PRAGMA EXCEPTION_INIT (duplicate_info, -00001);
     BEGIN
       INSERT INTO customers
         (customer_id, cust_last_name, cust_first_name)
     VALUES (
       :new.customer_id,
       :new.cust_last_name,
       :new.cust_first_name);
     INSERT INTO orders (order_id, order_date, customer_id)
     VALUES (
       :new.order_id,
       :new.order_date,
       :new.customer_id);
     EXCEPTION
       WHEN duplicate_info THEN
         RAISE_APPLICATION_ERROR (
           -20107,
           'Duplicate customer or order ID');
     END order_list_insert
     CROSSEDITION: NO
 BEFORE_STATEMENT: NO
       BEFORE_ROW: YES
        AFTER_ROW: NO
  AFTER_STATEMENT: NO
   INSTEAD_OF_ROW: YES
        FIRE_ONCE: YES
APPLY_SERVER_ONLY: NO
1 row in set