ALL_VALIDATION_DIRECTIVES

ALL_VALIDATION_DIRECTIVES describes validation directives accessible to the current user.

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: