ALL_PG_LABEL_PROPERTIES
ALL_PG_LABEL_PROPERTIES describes properties in the property graphs accessible to the current user.
Related Views
-
DBA_PG_LABEL_PROPERTIESdescribes properties in all property graphs in the database. -
USER_PG_LABEL_PROPERTIESdescribes properties in the property graphs owned by the current user. This view does not display theOWNERcolumn.
| 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:
|
|
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 AI Database 26ai.
See Also: