3.87 ALL_ASSERTIONS

ALL_ASSERTIONS displays assertions accessible to the current user.

This view displays assertions owned by the current user, as well as assertions owned by other users that involve at least one table on which the current user has at least one of the following object privileges: SELECT, INSERT, UPDATE, or DELETE.

Related Views

  • DBA_ASSERTIONS displays all assertions in the database.

  • USER_ASSERTIONS displays assertions owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the assertion

ASSERTION_NAME

VARCHAR2(128)

Name of the assertion

OBJECT_ID

NUMBER

NOT NULL

Object ID number of the assertion

You can join this column with the OBJECT_ID column of the ALL_OBJECTS view to obtain more details about the object.

STATUS

VARCHAR2(8)

Indicates whether the assertion is enfoced during execution of DML statements (ENABLED) or not (DISABLED)

DEFERRABLE

VARCHAR2(14)

Indicates whether the assertion is DEFERRABLE or NOT DEFERRABLE

DEFERRED

VARCHAR2(9)

Indicates whether the assertion is deferred by default (DEFERRED) or not (IMMEDIATE)

VALIDATED

VARCHAR2(13)

Indicates whether the database has validated that data in the involved tables of the assertion obeys the assertion (VALIDATED) or not (NOT VALIDATED)

INVALID

VARCHAR2(7)

Reserved for internal use

DEFINITION_SQL

CLOB

SQL text of the assertion definition

If the assertion is not owned by the current user, the value of this column is null.

Note:

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

See Also: