4.13 ALL_PG_LABEL_PROPERTIES

ALL_PG_LABEL_PROPERTIES describes properties in the property graphs accessible to the current user.

Related Views

• DBA_PG_LABEL_PROPERTIES describes properties in all property graphs in the database.

• USER_PG_LABEL_PROPERTIES describes 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
LABEL_NAME	VARCHAR2(128)	NOT NULL	Name of the label
PROPERTY_NAME	VARCHAR2(128)	NOT NULL	Name of the property
DATA_TYPE	VARCHAR2(106)		Data type of the property
DATA_LENGTH	NUMBER	NOT NULL	Length of the data type (in bytes)
DATA_PRECISION	NUMBER		Decimal precision for NUMBER data type; binary precision for FLOAT data type; null for all other data types
DATA_SCALE	NUMBER		Digits to the right of the decimal point in a number; null for all other data types
DATA_CHAR_LENGTH	NUMBER		Maximum length of the property (in characters)
CHARACTER_SET_NAME	VARCHAR2(44)		Name of the character set: CHAR_CS NCHAR_CS
COLLATION	VARCHAR2(100)		Collation for the column. Only applies to columns with character data types.
PROPERTY_ORDER	NUMBER	NOT NULL	Declaration order of the property in the label

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_PG_LABEL_PROPERTIES"

• "USER_PG_LABEL_PROPERTIES"