Using APEX_STRING.SPLIT in SQL
Finding matches in delimited strings and much more...
#sql
Posts tagged #sql
Improving Oracle SQL Query with Connect By Performance
Hierarchical / recursive queries are amazing…but can get slow with highly nested data sets.
Full Outer Join - How to Compare Tables
This started out as just a quick task of writing a SQL statement to compare two tables, but ultimately defined an approach for doing full outer joins.
