ALL_JSON_DUALITY_VIEW_TAB_COLS

ALL_JSON_DUALITY_VIEW_TAB_COLS describes the table columns associated with the JSON-relational duality views accessible to the current user.

DBA_JSON_DUALITY_VIEW_TAB_COLS describes the table columns associated with all JSON-relational duality views in the database.
USER_JSON_DUALITY_VIEW_TAB_COLS describes the table columns associated with the JSON-relational duality views owned by the current user. This view does not display the VIEW_OWNER column.

Column	Datatype	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
`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
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the column
`DATA_TYPE`	`VARCHAR2(128)`	Data type of the column
`LENGTH`	`NUMBER`	For character data types, the maximum length of the column (in characters)
`JSON_KEY_NAME`	`NVARCHAR2(128)`	JSON key name corresponding to the column
`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 changes to the column are prohibited (`TRUE`) or not (`FALSE`)
`IS_FLEX_COL`	`BOOLEAN`	Indicates whether the column is a flex column (`TRUE`) or not (`FALSE`)
`IS_GENERATED`	`BOOLEAN`	Indicates whether the value associated with `JSON_KEY_NAME` is a generated (`TRUE`) or not (`FALSE`)
`IS_HIDDEN`	`BOOLEAN`	Indicates whether `JSON_KEY_NAME` is hidden in the document (`TRUE`) or not (`FALSE`)
`PRIMARY_KEY_POS`	`NUMBER`	If the column is part of a primary key, its position in the primary key specification; otherwise, null
`ETAG_POS`	`NUMBER`	If the column is part of an ETAG, its position in the ETAG specification; otherwise, null
`ORDER_BY_POS`	`NUMBER`	If the column is part of the `ORDER` `BY` clause of the `JSON_ARRAYAGG` function, then its position in the `ORDER` `BY` clause; otherwise, null

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

“DBA_JSON_DUALITY_VIEW_TAB_COLS”
“USER_JSON_DUALITY_VIEW_TAB_COLS”

ALL_JSON_DUALITY_VIEW_TAB_COLS

Related Views