ALL_JSON_DUALITY_VIEW_TABS

Previous Next JavaScript must be enabled to correctly display this content

3.287 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: