Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer Graph Visualization Extension for VS Code and Quantified path pattern

Saqib AliAug 16 2025 — edited Aug 18 2025

Hi,

I am trying to use the SQL Developer Graph Visualization Extension for VS Code to visualize a Graph where the relationship can be multi-hop using a quantified path pattern:

select *
from GRAPH_TABLE(
match (c1 is customer) - [e is relationship]{1,10} -> (c2 is customer)
where c1.address_id = c2.address_id
columns (c1.name, c2.name)					

However this Visualization Extension requires the query must project vertex/edge IDs for the extension to work correctly.

How do I project the [e] edge of a variable length?

The following errors out:

select *
from GRAPH_TABLE(
match (c1 is customer) - [e is relationship]{1,10} -> (c2 is customer)
where c1.address_id = c2.address_id
columns (c1.name, c2.name, vertex_id(c1) as c1, vertex_id(c2) as c2 and edge_id(e) as e1);

Error:


ORA-40990: invalid reference of group variable E in the COLUMNS clause of a GRAPH_TABLE operator https://docs.oracle.com/error-help/db/ora-40990/
A group variable was referenced outside of the quantified path pattern in which it was declared

Please advise

Comments
Post Details
Added on Aug 16 2025
1 comment
61 views