4.9 ALL_PG_EDGE_RELATIONSHIPS
ALL_PG_EDGE_RELATIONSHIPS
describes edge relationships in the property graphs accessible to the current user.
This view displays one row for each key column used for an edge relationship. For example, an edge table defined as follows will result in two rows in this view:
EDGE TABLES(et1
SOURCE
KEY(cx, cy)
REFERENCES
vt1(fk1, fk2)
… )
Related Views
-
DBA_PG_EDGE_RELATIONSHIPS
describes edge relationships in all property graphs in the database. -
USER_PG_EDGE_RELATIONSHIPS
describes edge relationships in the property graphs owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the property graph |
|
|
|
Name of the property graph |
|
|
|
Name of the edge table |
|
|
|
Name of the vertex table |
|
|
|
Indicates whether the vertex table is a source vertex table (SOURCE ) or a destination vertex table (DESTINATION )
|
|
|
|
Name of the foreign column in the edge table |
|
|
|
Name of the referenced column in the vertex table |
Note:
This view is available starting with Oracle Database 23ai.
See Also: