DiagnosticsListener improvements A lot of additional diagnostics have been added, including the automated detection of pattern replacements, helping you lint your SQL queries irrespective of whether you're using jOOQ to write your SQL, or if you're using it as a JDBC / R2DBC proxy for an existing application. A lot of these diagnostics are available … Continue reading 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0
Category: Uncategorized
A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL
Every now and then I run across a use case for the arcane NATURAL JOIN SQL operator, and I'm even more delighted when I can make that a NATURAL FULL JOIN. A few past blog posts on the subject include: Use NATURAL FULL JOIN to compare two tables in SQLImpress Your Coworkers With the Incredible … Continue reading A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL