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