SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Takipçi

4 Takip Edilen

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

2 years ago

Finding rock-scissors-paper (A beats B beats C beats A) triangles is tricky with #SQL SQL/PGQ in the SQL:2023 standard & Oracle Database 23c simplifies this Use GRAPH_TABLE to find paths: MATCH ( A ) -[ WHERE a_win ]-> ( B ) -[ WHERE b_win ]-> ( C ) -[ WHERE c_win ]-> ( A )