Query dba_trigger table : dba_triggers « System Tables Views « Oracle PL / SQL

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

Query dba_trigger table

 
SQL>
SQL> set linesize 77
SQL>  column triggering_event format a30
SQL>  column trigger_name format a20
SQL>
SQL>  select trigger_name,
  2            triggering_event,
  3             trigger_type,
  4             status
  5        from dba_triggers
  6       where rownum < 50
  7      /
TRIGGER_NAME         TRIGGERING_EVENT               TRIGGER_TYPE
-------------------- ------------------------------ ----------------
STATUS
----------
DEF$_PROPAGATOR_TRIG INSERT                         BEFORE STATEMENT
ENABLED

REPCATLOGTRIG        UPDATE OR DELETE               AFTER STATEMENT
ENABLED

XDB_RV_TRIG          INSERT OR UPDATE OR DELETE     INSTEAD OF
ENABLED

XDB$ACL$xd           UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

xdb-log44_TAB$xd     UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

SERVLET$xd           UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

ftp-log65_TAB$xd     UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

http-log86_TAB$xd    UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

Folder103_TAB$xd     UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

XDB_PV_TRIG          INSERT OR UPDATE OR DELETE     INSTEAD OF
ENABLED

XDB$STATS$xd         UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

XDB$CONFIG$xd        UPDATE OR DELETE               BEFORE EACH ROW
ENABLED

XDBCONFIG_VALIDATE   INSERT OR UPDATE               BEFORE EACH ROW
ENABLED

SDO_GEOM_TRIG_INS1   INSERT                         INSTEAD OF
ENABLED

SDO_GEOM_TRIG_DEL1   DELETE                         INSTEAD OF
ENABLED

SDO_GEOM_TRIG_UPD1   UPDATE                         INSTEAD OF
ENABLED

SDO_LRS_TRIG_INS     INSERT                         INSTEAD OF
ENABLED

SDO_LRS_TRIG_DEL     DELETE                         INSTEAD OF
ENABLED

SDO_COORD_OP_METHODS INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
_TRIGGER
ENABLED

SDO_LRS_TRIG_UPD     UPDATE                         INSTEAD OF
ENABLED

SDO_TOPO_TRIG_INS1   INSERT                         INSTEAD OF
ENABLED

SDO_PREFERRED_OPS_SY INSERT OR UPDATE               BEFORE EACH ROW
S_TRIGGER
ENABLED

SDO_PREFERRED_OPS_US INSERT OR UPDATE               BEFORE EACH ROW
ER_TRIGGER
ENABLED

SDO_COORD_OP_PATHS_T INSERT OR UPDATE               BEFORE EACH ROW
RIGGER
ENABLED

CS_SRS_TRIGGER       INSERT OR UPDATE OR DELETE     INSTEAD OF
ENABLED

SDO_CRS_INSERT_TRIGG INSERT                         INSTEAD OF
ER
ENABLED

SDO_CRS_DELETE_TRIGG DELETE                         INSTEAD OF
ER
ENABLED

OGIS_CRS_INSERT_TRIG INSERT                         BEFORE EACH ROW
GER
ENABLED

OGIS_CRS_DELETE_TRIG DELETE                         BEFORE EACH ROW
GER
ENABLED

SECURE_EMPLOYEES     INSERT OR UPDATE OR DELETE     BEFORE STATEMENT
DISABLED

UPDATE_JOB_HISTORY   UPDATE                         AFTER EACH ROW
ENABLED

WWV_BIU_FLOW_FEEDBAC INSERT OR UPDATE               BEFORE EACH ROW
K
ENABLED

WWV_BIU_FLOW_BUILD_A INSERT OR UPDATE               BEFORE EACH ROW
UDIT_T
ENABLED

WWV_BIU_FLOWS_AUDIT  INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
ENABLED

WWV_BIU_FLOW_TMPLTS_ INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
AUDIT
ENABLED

WWV_BIU_FLOW_ICON_BA INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
R_AUDIT
ENABLED

WWV_BIU_PROCESSING_A INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
UDIT
ENABLED

WWV_BIU_FLOW_ITEMS_A INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
UDIT
ENABLED

WWV_BIU_COMPUTATIONS INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
_AUDIT
ENABLED

WWV_BIU_FLOW_TABS_AU INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
DIT
ENABLED

WWV_BIU_FLOW_TL_TABS INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
_AUDIT
ENABLED

WWV_BIU_FLOW_LOV_AUD INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
IT
ENABLED

WWV_BIU_FLOW_LOVD_AU INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
DIT
ENABLED

WWV_BIU_FLOW_STEPS_A INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
UDIT
ENABLED

WWV_BIU_STEP_BUTTONS INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
_AUDIT
ENABLED

WWV_BIU_STEP_BRANCHE INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
S_AUDIT
ENABLED

WWV_BIU_STEP_BRANCH_ INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
ARGS_AUDIT
ENABLED

WWV_BIU_STEP_ITEMS_A INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
UDIT
ENABLED

WWV_BIU_FLOW_MENU_OP INSERT OR UPDATE OR DELETE     BEFORE EACH ROW
T_AUDIT
ENABLED


49 rows selected.

SQL> --

 

Related examples in the same category