3.271 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)

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_JSON_DUALITY_VIEWS"

• "USER_JSON_DUALITY_VIEWS"