3.273 ALL_JSON_SCHEMA_COLUMNS

ALL_JSON_SCHEMA_COLUMNS describes JSON schema constraints on columns in tables accessible to the current user.

Related Views

• DBA_JSON_SCHEMA_COLUMNS describes JSON schema constraints on columns in all tables in the database.

• USER_JSON_SCHEMA_COLUMNS describes JSON schema constraints on columns in tables 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 table containing the column on which the JSON schema constraint is defined
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the table containing the column on which the JSON schema constraint is defined
COLUMN_NAME	VARCHAR2(128)	NOT NULL	Name of the 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_SCHEMA_COLUMNS"

• "USER_JSON_SCHEMA_COLUMNS"