What Is Nelson's Syndrome

Oracle Oracle Trigger

The main triggers are tables covering the following :

user_sequences

user_triggers

all_triggers

here are their descriptions:

SQL> desc user_triggers

Name Null?

Type --------------------------- -------- ---------- ---------------------------------------

TRIGGER_NAME VARCHAR2(30)

TRIGGER_TYPE VARCHAR2(16)

TRIGGERING_EVENT VARCHAR2(216)

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> desc user_sequences

Name Null? Type

--------------------------- -------- -------------------------------------------------

SEQUENCE_NAME NOT NULL VARCHAR2(30)

MIN_VALUE NUMBER

MAX_VALUE NUMBER

INCREMENT_BY NOT NULL NUMBER

CYCLE_FLAG VARCHAR2(1)

ORDER_FLAG VARCHAR2(1)

CACHE_SIZE NOT NULL NUMBER

LAST_NUMBER NOT NULL NUMBER

SQL> desc all_triggers

Name Null? Type

--------------------------- -------- -------------------------------------------------

OWNER VARCHAR2(30)

TRIGGER_NAME VARCHAR2(30)

TRIGGER_TYPE VARCHAR2(16)

TRIGGERING_EVENT VARCHAR2(216)

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

select This gives us an overview of the trigger of our interest:

SQL> SELECT trigger_name, trigger_body from all_triggers WHERE trigger_name = '';

instead and this gives us the status:

SQL> select status from all_triggers WHERE trigger_name = 'CUSTOM_CDR_DATA_RTRIG';