JavaScript must be enabled to correctly display this content

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.

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 AI Database 26ai.

See Also:

“DBA_JSON_DOMAIN_SCHEMA_COLUMNS”
“USER_JSON_DOMAIN_SCHEMA_COLUMNS”