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

This post has been answered by Saqib Ali on Aug 17 2025
Jump to Answer
Comments
Post Details
Added on Aug 16 2025
2 comments
122 views