Oracle Compliance with SQL/PGQ

Table Table C-4 describes Oracle's support for the features of SQL/PGQ.

Table C-4 Oracle Support for Features of SQL/PGQ

Feature ID	Feature Support
G000, Graph pattern	Oracle fully supports this feature.
G001, Repeatable-elements match mode	Oracle fully supports this feature.
G008, Graph pattern WHERE clause	Oracle fully supports this feature.
G034, Path concatenation	Oracle fully supports this feature.
G035, Quantified paths	Oracle fully supports this feature.
G036, Quantified edges	Oracle fully supports this feature.
G037, Questioned paths	Oracle fully supports this feature.
G040, Vertex pattern	Oracle fully supports this feature.
G042, Basic full edge patterns	Oracle fully supports this feature.
G044, Basic abbreviated edge patterns	Oracle fully supports this feature.
G060, Bounded graph pattern quantifiers	Oracle fully supports this feature.
G070, Label expression: label disjunction	Oracle fully supports this feature.
G071, Label expression: label conjunction	Oracle provides equivalent functionality using label expressions on different graph patterns with the same graph element variable name.
G073, Label expression: individual label name	Oracle fully supports this feature.
G090, Property reference	Oracle fully supports this feature.
G100, ELEMENT_ID function	Oracle provides equivalent functionality using EDGE_ID and VERTEX_ID operators.
G112, IS SOURCE and IS DESTINATION predicate	Oracle fully supports this feature.
G114, SAME predicate	Oracle provides equivalent functionality using VERTEX_EQUAL and EDGE_EQUAL predicates.
G120, Within-match aggregates	Oracle fully supports this feature.
G900, GRAPH_TABLE	Oracle fully supports this feature.
G904, All properties reference	Oracle supports this feature in the COLUMNS clause.
G920, DDL-based SQL-property graphs	Oracle fully supports this feature with the following exception: the keyword RESTRICT is not supported for the DROP PROPERTY GRAPH statement.
G924, Explicit key clause for element tables	Oracle fully supports this feature.
G925, Explicit label and properties clause for element tables	Oracle fully supports this feature.
G926, More than one label for vertex tables	Oracle fully supports this feature.
G927, More than one label for edge tables	Oracle fully supports this feature.
G928, Value expressions as properties and renaming of properties	Oracle fully supports this feature.
G929, Labels and properties: EXCEPT list	Oracle fully supports this feature.
G940, Multi-sourced and multi-destined edges	Oracle fully supports this feature.
G941, Implicit removal of incomplete edges	Oracle fully supports this feature.