4.15 ALL_PG_PROP_DEFINITIONS

ALL_PG_PROP_DEFINITIONS describes columns and expressions exposed as properties in the property graphs accessible to the current user.

Related Views

  • DBA_PG_PROP_DEFINITIONS describes columns and expressions exposed as properties in all property graphs in the database.

  • USER_PG_PROP_DEFINITIONS describes columns and expressions exposed as properties in the property graphs owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the property graph

GRAPH_NAME

VARCHAR2(128)

NOT NULL

Name of the property graph

ELEMENT_NAME

VARCHAR2(128)

NOT NULL

Name of the element table

PROPERTY_NAME

VARCHAR2(128)

NOT NULL

Name of the property

COLUMN_NAME

VARCHAR2(128)

Column exposed by the property

COLUMN_EXPR

LONG

Expression exposed by the property

Note:

This view is available starting with Oracle Database 23ai.