3.288 ALL_JSON_DUALITY_VIEWS

ALL_JSON_DUALITY_VIEWS describes the JSON-relational duality views accessible to the current user.

Related Views

  • DBA_JSON_DUALITY_VIEWS describes all JSON-relational duality views in the database.

  • USER_JSON_DUALITY_VIEWS describes the JSON-relational duality views owned by the current user. This view does not display the VIEW_OWNER column.

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 (ENABLED) or not (DISABLED)

This setting is ignored if database-wide column data supplemental logging is enabled.

Footnote 1 This column is available starting with Oracle Database 23ai, Release Update 23.6.

Note:

This view is available starting with Oracle Database 23ai.

See Also: