Migrated Articles
- A Note on Oracle Join Orders and Hints (2016-07-17)
- A Template Script for JDBC Integration Testing of Oracle Procedures (2016-05-14)
- Code Timing and Object Orientation and Zombies (2016-05-07)
- Recursive SQL for Network Analysis, and Duality (2015-09-02)
- SQL Developer: Importing Unit Test Repository via Data Modeler (2015-07-11)
- PL/SQL Pipelined Function for Network Analysis (2015-05-10)
- SQL for Shortest Path Problems 2: A Branch and Bound Approach (2015-05-04)
- SQL for Shortest Path Problems (2015-04-19)
- Unix Snippets for Handling Duplicate Keys in Delimited Input Files (2014-11-30)
- A Generic Unix Script for Uploading eBusiness Concurrent Programs (2014-09-28)
- Design Patterns for Database Reports with XML Publisher and Email Bursting (2014-09-20)
- Query Query Query (2014-09-03)
- A Design Pattern for Oracle eBusiness Audit Trail Reports with XML Publisher (2014-08-31)
- NoCOUG SQL Challenge 2014 Illustrated (2014-08-25)
- Low-Hanging Fruit: The Classic Performance Tuning Anti-pattern (2014-07-28)
- Brendan's 2-Page Oracle Programming Standards (2014-05-24)
- SQL for Continuum and Contiguity Grouping (2013-11-16)
- Messages from Outer Space (2013-10-15)
- SQL and Modularity: Patterns, Anti-Patterns and the Kitchen Sink (2013-09-08)
- SQL for Length-Controlled List Aggregation (2013-08-17)
- SQL for the Travelling Salesman Problem (2013-07-14)
- SQL for the Balanced Number Partitioning Problem (2013-05-25)
- Design Patterns for Extracting Relational Data from XML (2013-04-21)
- SQL for Network Grouping (2013-03-23)
- PL/SQL Profiling 1 - Overview (2013-03-05)
- An SQL Solution for the Multiple Knapsack Problem (SKP-m) (2013-01-20)
- A Simple SQL Solution for the Knapsack Problem (SKP-1) (2013-01-06)
- Master-Detail Transaction Reconciliation in SQL (MDTM3) (2012-10-26)
- Holographic Set Matching in SQL (MDTM2) (2012-10-12)
- Master-Detail Transaction Matching in SQL (MDTM1) (2012-10-10)
- List Aggregation in Oracle - Comparing Three Methods (2012-09-30)
- Grouping by Unique Subsequences in SQL (2012-09-08)
- Query Structure Diagramming (2012-08-11)
- A Layered Approach To Processing XML Web Services (2012-02-05)
- Data Modelling of XML SOAP Documents (2012-01-29)
- Data Structure Diagramming (2012-01-21)
- Case Expressions and Ignoring Nulls in Analytic Functions (2012-01-15)