3.193 ALL_DIRECTIVES

ALL_DIRECTIVES describes the directives accessible to the current user.

Related Views

  • DBA_DIRECTIVES describes all directives in the database.

  • USER_DIRECTIVES describes the directives owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the directive

DIRECTIVE_NAME

VARCHAR2(128)

NOT NULL

Name of the directive

DIRECTIVE_TYPE

VARCHAR2(9)

Type of the directive

The value of this column is always NOTIFY.

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the table or duality view object associated with the directive

STATUS

VARCHAR2(9)

Indicates whether the directive will be evaluated (ENABLED) or not (DISABLED)

VALIDATED

VARCHAR2(10)

Reserved for future use

ON_CLAUSE

VARCHAR2(36)

Operations that will trigger the directive

This column displays a list of one or more of the following operations:

  • DELETE

  • INSERT

  • SELECT

  • UPDATE

USING_TYPE

VARCHAR2(16)

Using type of the directive

The value of this column is always NOTIFICATION LOG.

USING_CLAUSE

VARCHAR2(4000)

Using clause of the directive

PROCESSING_STAGE_CLAUSE

VARCHAR2(15)

Reserved for future use

SCOPE_STAGE

VARCHAR2(12)

Reserved for future use

See Also: