Tuesday 24 September 2013

Structure of Oracle dba_trigers

Name                                                Null?                             Type
 -----------------------------------------             --------                 ----------------------------
 OWNER                                                                        VARCHAR2(30)
 TRIGGER_NAME                                                       VARCHAR2(30)
 TRIGGER_TYPE                                                         VARCHAR2(16)
 TRIGGERING_EVENT                                               VARCHAR2(227)
 TABLE_OWNER                                                          VARCHAR2(30)
 BASE_OBJECT_TYPE                                                 VARCHAR2(16)
 TABLE_NAME                                                              VARCHAR2(30)
 COLUMN_NAME                                                        VARCHAR2(4000)
 REFERENCING_NAMES                                             VARCHAR2(128)
 WHEN_CLAUSE                                                            VARCHAR2(4000)
 STATUS                                                                           VARCHAR2(8)
 DESCRIPTION                                                              VARCHAR2(4000)
 ACTION_TYPE                                                             VARCHAR2(11)
 TRIGGER_BODY                                                           LONG

No comments:

Post a Comment