#oracle

Articles tagged with #oracle

Using APEX_STRING.SPLIT in SQL
Finding matches in delimited strings and much more...
Mar 15, 20263 min read154
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
Mark This Down
Am I the only person that likes writing documentation?
Jan 31, 20254 min read728
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
Writing fast queries
There is a lot that goes into writing queries that run quickly and I've been struggling with how to teach this. Below are a few of the things I strive for when writing queries. These are just basic things that I attempt to do every time I write a que...
Mar 30, 20239 min read1.3K
Updated APEX Resource Manager Plan
Every Oracle database should have a resource plan. This plan is a good start if you are primarily using APEX applications.
Mar 3, 202310 min read387