[Wranglers] Running SQL Graph Queries in Oracle at a Specific SCN

[Ali, Saqib]

I did not know you can Time Travel in SQL Graph Queries in Oracle by
specifying the System Change Number (SCN) or the TIMESTAMP:
https://docs.oracle.com/en/database/oracle/property-graph/25.1/spgdg/running-sql-graph-queries-specific-scn.html?source=%3Aem%3Anw%3Amt%3A%3A%3A%3ARC_DEVT230612P00024C00002%3ANSL400299976


e.g.
SELECT * FROM GRAPH_TABLE (students_graph AS OF SCN 2117789
  MATCH
   (a IS person) -[e]-> (b IS person)
  COLUMNS (a.name AS a, b.name AS b, e.meeting_date AS met_on)
  );

SQL> SELECT * FROM GRAPH_TABLE (students_graph AS OF TIMESTAMP SYSTIMESTAMP
  MATCH
   (a IS person WHERE a.name='John') -[e]-> (b IS person)
  COLUMNS (a.name AS a, b.name AS b, e.meeting_date AS met_on)
  );

This is a unique feature that most Graph Databases do not provide.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250603/6952e7c7/attachment-0001.htm>