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.

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. This implies a 0 to many relationship, which is a cardinality-expanding join.

  • outer - Foreign key to primary key: This implies a 0 to 1 relationship. This is a cardinality-preserving join, but it is possible that no TO value is found for a FROM value.

  • inner - This implies a 1 to 1 relationship. This is a cardinality-preserving join where, for each FROM value, one corresponding TO value is guaranteed. 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 AI Database 26ai.

See Also: