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_COLUMNSdescribes JSON schema constraints on columns in all tables in the database. -
USER_JSON_SCHEMA_COLUMNSdescribes JSON schema constraints on columns in tables owned by the current user. This view does not display theOWNERcolumn.
| 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 AI Database 26ai.
See Also: