Using APEX_STRING.SPLIT in SQL
Finding matches in delimited strings and much more...
Mar 15, 20263 min read154
Command Palette
Search for a command to run...
#sql
Articles tagged with #sql
Improving Oracle SQL Query with Connect By Performance
Hierarchical / recursive queries are amazing…but can get slow with highly nested data sets.
Apr 22, 20252 min read862
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.
Dec 11, 20245 min read369