3.270 ALL_JSON_DUALITY_VIEW_TABS

ALL_JSON_DUALITY_VIEW_TABS describes the tables associated with the JSON-relational duality views accessible to the current user.

Related Views

• DBA_JSON_DUALITY_VIEW_TABS describes the tables associated with all JSON-relational duality views in the database.

• USER_JSON_DUALITY_VIEW_TABS describes the tables associated with 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
TABLE_OWNER	VARCHAR2(128)		Owner of the table
TABLE_NAME	VARCHAR2(128)		Name of the table
WHERE_CLAUSE	NVARCHAR2(128)		SQL expression in the WHERE clause of the duality view query that accesses the table If the query does not contain a WHERE clause, then null.
ALLOW_INSERT	BOOLEAN		Indicates whether rows can be inserted into the table using the duality view (TRUE) or not (FALSE)
ALLOW_UPDATE	BOOLEAN		Indicates whether the column can be updated using the duality view (TRUE) or not (FALSE)
ALLOW_DELETE	BOOLEAN		Indicates whether rows can be deleted from the table using the duality view (TRUE) or not (FALSE)
READ_ONLY	BOOLEAN		Indicates whether the table is read-only in the duality view, that is, no rows can be modified, inserted, or deleted (TRUE) or not (FALSE)
HAS_FLEX_COL	BOOLEAN		Indicates whether the table contains a flex column (TRUE) or not (FALSE)
ROOT_TABLE	BOOLEAN		Indicates whether the table is the root (topmost) table (TRUE) or not (FALSE)
TABLE_NUMBER	NUMBER		Number value that identifies this table in the duality view
PARENT_TABLE_NUMBER	NUMBER		Number value that points to the parent table in the hierarchy
RELATIONSHIP	VARCHAR2(10)		Relationship between the table (that is, the child table) and the parent table: NESTED - The child table is nested as a JSON array under the parent table REFERENCED - The child table is the target of an outer join SINGLETON - The child table is the target of an inner join

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_JSON_DUALITY_VIEW_TABS"

• "USER_JSON_DUALITY_VIEW_TABS"