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 the default `UPDATE` clause for columns belonging to the table: `TRUE` - Columns can be updated `FALSE` - Columns cannot be updated Note that this default can be overridden on a per-column basis. See "ALL_JSON_DUALITY_VIEW_TAB_COLS" for column-specific information.
`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 can return 0 to many rows for each row of the parent table. The corresponding JSON shows the child table's value in a JSON array. `singleton` - The child table can return 0 to 1 row for each row of the parent table.

Note:

This view is available starting with Oracle Database 23ai.

See Also: