3.284 ALL_JSON_DOMAIN_SCHEMA_COLUMNS

ALL_JSON_DOMAIN_SCHEMA_COLUMNS describes JSON schema constraints on columns of data use case domains accessible to the current user.

Related Views

  • DBA_JSON_DOMAIN_SCHEMA_COLUMNS describes JSON schema constraints on columns of all data use case domains in the database.

  • USER_JSON_DOMAIN_SCHEMA_COLUMNS describes JSON schema constraints on columns of data use case domains 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 data use case domain containing the column on which the JSON schema constraint is defined

DOMAIN_NAME

VARCHAR2(128)

NOT NULL

Name of the data use case domain containing the column on which the JSON schema constraint is defined

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the data use case domain column on which the JSON schema constraint is defined

CONSTRAINT_NAME

VARCHAR2(128)

NOT NULL

Name of the JSON schema constraint

JSON_SCHEMA

JSON

JSON schema constraint definition

CAST_MODE

BOOLEAN

Indicates whether the JSON schema validator is operating in cast mode (TRUE) or not (FALSE)

Note:

This view is available starting with Oracle Database 23ai.

See Also: