3.272 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:

• "DBA_JSON_DOMAIN_SCHEMA_COLUMNS"

• "USER_JSON_DOMAIN_SCHEMA_COLUMNS"