| 01/22/2022 | Protecting/Hiding Data in Oracle |
| Using Oracle Fine Grained Access Control to implement a protected datastore for ssh private keys | |
| 01/18/2022 | HTML Table Markup Redux |
| HTML and CSS suck once again, but we can overcome. | |
| 01/16/2022 | HTML Table Markup in Oracle |
| A small enhancement to the venerable DBMS_XMLGEN/XLSTYPE technique for turning a query resultset into a HTML table. | |
| 01/09/2022 | More CSV Fun - Turn CSV into SQL Resultset |
| A pattern for turning CSV data into an Oracle Resultset you can use in a query or DML. | |
| 01/02/2022 | Perl Like Operations in PL/SQL |
| Transforming lists and hacking strings from lists is a staple of Perl programming. PL/SQL makes it more challenging than it needs to be. Presenting a better way with the perlish_util_udt Oracle Object type. | |
| 12/31/2021 | Polymorphic Table Function (PTF) for CSV (take 3) |
| My journey with PTFs has us more closely aligning with established patterns plus an extended explanation of Replication Factor and how to use it. This article walks through the parts of a PTF with detail and explanation I wish I had seen while I was learning. | |
| 12/28/2021 | Polymorphic Table Function for CSV (take 2) |
| Continuing the journey with PTFs for parsing a CSV CLOB. | |
| 12/27/2021 | Polymorphic Table Function to the Rescue? |
| I get my feet wet with a Polymorphic Table Function to parse CSV data from a CLOB. |