4.161 ALL_VALIDATION_DIRECTIVES

ALL_VALIDATION_DIRECTIVES describes validation directives accessible to the current user.

Related Views

  • DBA_VALIDATION_DIRECTIVES describes all validation directives in the database.

  • USER_VALIDATION_DIRECTIVES describes validation 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 validation directive

DIRECTIVE_NAME

VARCHAR2(128)

NOT NULL

Name of the validation directive

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the object on which the validation directive is defined

STATUS

VARCHAR2(9)

Status of the validation directive:

  • ENABLED - The validation directive will be evaluated

  • DISABLED - The validation directive will not be evaluated

VALIDATED

VARCHAR2(10)

Validation status of the validation directive:

  • VALIDATE - Existing data is validated

  • NOVALIDATE - Existing data is not validated

ON_CLAUSE

VARCHAR2(26)

Statements on which the validation directive will fire. Displays one of more of the following:

  • INSERT

  • SELECT

  • UPDATE

USING_TYPE

VARCHAR2(15)

Type of construct specified in the USING clause for the validation directive:

  • ANONYMOUS BLOCK

  • EXPRESSION

  • FUNCTION

USING_CLAUSE

VARCHAR2(4000)

Text of the USING clause for the validation directive

PROCESSING_STAGE_CLAUSE

VARCHAR2(15)

Indicates when, during statement or transaction execution, the validation directive will be evaluated:

  • BEFORE OBJECT

  • AFTER OBJECT

  • ON COMMIT

SCOPE_CLAUSE

VARCHAR2(12)

Scope of operations that result in the evaluation of the validation directive:

  • SCOPE OBJECT

  • SCOPE VIEW

  • SCOPE ALL

ERROR_LOG_OBJN

NUMBER

Reserved for future use

ORDER#

NUMBER

NOT NULL

Position of the validation directive in the firing order for the object

The validation directive with the lowest ORDER# is fired first, then the validation directive with the second lowest ORDER# is fired, and so on.

Note:

This view is available starting with Oracle AI Database 26ai, Release Update 23.26.2.

See Also: