ALL_JSON_DUALITY_VIEW_LINKS

Previous Next JavaScript must be enabled to correctly display this content

3.285 ALL_JSON_DUALITY_VIEW_LINKS

ALL_JSON_DUALITY_VIEW_LINKS describes the links associated with the JSON-relational duality views accessible to the current user.

Related Views

DBA_JSON_DUALITY_VIEW_LINKS describes the links associated with all JSON-relational duality views in the database.
USER_JSON_DUALITY_VIEW_LINKS describes the links 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
`PARENT_TABLE_OWNER`	`VARCHAR2(128)`		Owner of the parent table in the link
`PARENT_TABLE_NAME`	`VARCHAR2(128)`		Name of the parent table in the link
`CHILD_TABLE_OWNER`	`VARCHAR2(128)`		Owner of the child table in the link
`CHILD_TABLE_NAME`	`VARCHAR2(128)`		Name of the child table in the link
`FROM_COLUMN`	`VARCHAR2(128)`		Name of the column on the `FROM` side of the link
`TO_COLUMN`	`VARCHAR2(128)`		Name of the column on the `TO` side of the link
`JOIN_TYPE`	`VARCHAR2(16)`		Join type for the link: `NESTED` - Primary key to foreign key `OUTER` - Foreign key to primary key `INNER` - This value is currently not used
`KEY_NAME`	`VARCHAR2(128)`		Name of the JSON key associated with the link

Note:

This view is available starting with Oracle Database 23ai.

See Also: