Oracle PL/SQL Tutorial/System Tables Data Dictionary/all triggers

Материал из SQL эксперт
Перейти к: навигация, поиск

Get information on all the triggers you have access to using all_triggers.

   <source lang="sql">

SQL> SQL> desc all_triggers;

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

SQL> SQL> --select * from all_triggers;</source>