| 04/10/2022 | Profiling PL/SQL to Examine Context Switch Penalty |
| A deeper dive into the performance cost of calling a PL/SQL function from SQL. We use the PL/SQL Hierarchical Profiler to explore whether context switching is the villain for our CSV parser. Spoiler alert: it is not clear. | |
| 04/10/2022 | Oracle REGEXP_INSTR and Beginning of Line Anchor |
| REGEXP_INSTR *position* parameter gives non-intuitive behavior for '^' beginning of line anchor. | |
| 04/02/2022 | Cost of UDT Object Methods in SQL |
| A journey to optimize some unexpectedly slow code with Chained Pipeline Row Functions. | |
| 03/28/2022 | Devops Data Deployment for Oracle |
| Is your Devops Continuous Improvement deployment tool for Oracle cramping your style? I present one way of making it better for the case where you need to deploy data in addition to code. | |
| 03/20/2022 | A Ruby/Rouge Lexer Class for Oracle PL/SQL |
| I take a side cruise with an unfamiliar language, but hey, it's regular expressions and tokens. How hard can it be? Turns out not that bad. | |
| 03/06/2022 | Staging Tables vs Single SQL |
| One gigantic INSERT query or multiple small ones? Why choose when you can break the big one up into Common Table Expressions via the SQL WITH clause? Of course there are exceptions. Let's explore some. | |
| 01/24/2022 | Inline External Tables for CSV Load |
| If you can deliver CSV data to an Oracle Directory, you can parse it without deploying any code by using an Inline External Table | |
| 01/23/2022 | CSV Clob and Private Temporary Table |
| Converting CSV data into an Oracle resultset via Private Temporary Table (PTT) |