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

• "DBA_JSON_DUALITY_VIEW_LINKS"

• "USER_JSON_DUALITY_VIEW_LINKS"