Quettabyte
Gist | Mastodon | Threads
Oracle Built-in Graph Algorithms
SQL/PGQ
SELECT id, comp_id
FROM GRAPH_TABLE (
  DBMS_OGA.wcc (
    bank_graph,
    PROPERTY(VERTEX OUTPUT comp_id))
  MATCH (a IS Accounts)
  COLUMNS (a.id, a.comp_id)
) FETCH FIRST 5 ROWS ONLY;
Created on Wed, 26 Aug 2026 21:11:17 +0000 | URL: https://quettabyte.net/gist.php?id=5WGGH

Code screenshot

Oracle Built-in Graph Algorithms - Pinterest Image

« Create Another Gist