JavaScript must be enabled to correctly display this content

ALL_DIRECTIVES

ALL_DIRECTIVES describes the directives accessible to the current user.

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

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.4.

See Also:

“DBA_DIRECTIVES”
“USER_DIRECTIVES”