ALL_JSON_DUALITY_VIEWS
ALL_JSON_DUALITY_VIEWS describes the JSON-relational duality views accessible to the current user.
Related Views
-
DBA_JSON_DUALITY_VIEWSdescribes all JSON-relational duality views in the database. -
USER_JSON_DUALITY_VIEWSdescribes the JSON-relational duality views owned by the current user. This view does not display theVIEW_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
VIEW_OWNER |
VARCHAR2(128) |
Owner of the duality view | |
VIEW_NAME |
VARCHAR2(128) |
Name of the duality view | |
JSON_COLUMN_NAME |
CHAR(4) |
Name of the column containing the JSON data | |
ROOT_TABLE_NAME |
VARCHAR2(128) |
Name of the root table | |
ROOT_TABLE_OWNER |
VARCHAR2(128) |
Owner of the root table | |
ALLOW_INSERT |
BOOLEAN |
Indicates whether inserts of top level objects or sub-objects into the duality view are allowed (TRUE) or not (FALSE) |
|
ALLOW_UPDATE |
BOOLEAN |
Indicates whether updates to top level objects or sub-objects in the duality view are allowed (TRUE) or not (FALSE) |
|
ALLOW_DELETE |
BOOLEAN |
Indicates whether deletes of top level objects or sub-objects from the duality view are allowed (TRUE) or not (FALSE) |
|
READ_ONLY |
BOOLEAN |
Indicates whether the duality view is read-only, that is, no objects or sub-objects can be modified, inserted, or deleted (TRUE) or not (FALSE) |
|
JSON_SCHEMA |
JSON |
JSON schema description of the JSON data | |
STATUS |
VARCHAR2(7) |
Status of the duality view (VALID or INVALID) |
|
LOGICAL_REPLICATIONFoot 1 |
VARCHAR2(8) |
Indicates whether the duality view is enabled for logical replication ( This setting is ignored if database-wide column data supplemental logging is enabled. |
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.6.
Note: This view is available starting with Oracle AI Database 26ai.
See Also: