corpus.blog
56,966 blogs · [ { "id": "01a0872c-ebbf-73e6-abea-71d8fddd7e8e", "title": "Coupons, Caps and Functions – Intro", "url": "https://aprogrammerwrites.eu/?p=3150", "published_at": "2025-06-30T08:49:30+00:00" }, { "id": "01a0872c-ebbf-73e6-abea-71d8fe26233b", "title": "Optimization Problems with Items and Categories in Oracle – Intro", "url": "https://aprogrammerwrites.eu/?p=3138", "published_at": "2024-08-26T06:10:25+00:00" }, { "id": "01a0872c-ebbf-73e6-abea-71d8ff04517b", "title": "Oracle User Group Ireland Presentations", "url": "https://aprogrammerwrites.eu/?p=3124", "published_at": "2023-10-22T12:59:57+00:00" }, { "id": "01a0d544-4463-7269-af62-332d67fac888", "title": "The Math Function Unit Testing Design Pattern – Introduction", "url": "https://aprogrammerwrites.eu/?p=3108", "published_at": "2023-06-05T12:20:36+00:00" }, { "id": "01a0d544-4463-7269-af62-332d687195c7", "title": "A Note on Updates to Unit Testing Projects", "url": "https://aprogrammerwrites.eu/?p=3099", "published_at": "2023-05-07T13:22:16+00:00" }, { "id": "01a0d544-4463-7269-af62-332d6884154f", "title": "Analysing Performance of Algorithmic SQL and PL/SQL – Ireland Oracle User Group Conference 2022", "url": "https://aprogrammerwrites.eu/?p=3075", "published_at": "2022-08-21T07:31:44+00:00" }, { "id": "01a0d546-eb2b-7098-b0e0-641b1a2cd3ac", "title": "Shortest Path Analysis of Large Networks by SQL and PL/SQL – Intro", "url": "https://aprogrammerwrites.eu/?p=3065", "published_at": "2022-08-12T06:46:42+00:00" }, { "id": "01a0d546-eb2b-7098-b0e0-641b1a5a373c", "title": "Unit Testing, Scenarios and Categories: The SCAN Method – Intro", "url": "https://aprogrammerwrites.eu/?p=3031", "published_at": "2021-10-17T14:32:01+00:00" }, { "id": "01a0d546-eb2b-7098-b0e0-641b1af8dfac", "title": "SQL for Period Aggregate Reporting", "url": "https://aprogrammerwrites.eu/?p=3006", "published_at": "2021-02-28T16:21:34+00:00" }, { "id": "01a0d547-aede-70c3-9c53-3e8a470bbe3f", "title": "PL/SQL Profiling 4: Custom Code Timing", "url": "https://aprogrammerwrites.eu/?p=2869", "published_at": "2020-06-28T15:15:13+00:00" }, { "id": "01a0d547-aede-70c3-9c53-3e8a47caeab2", "title": "PL/SQL Profiling 3: Flat Profiler", "url": "https://aprogrammerwrites.eu/?p=2867", "published_at": "2020-06-28T15:14:49+00:00" }, { "id": "01a0d547-aede-70c3-9c53-3e8a488531c3", "title": "PL/SQL Profiling 2: Hierarchical Profiler", "url": "https://aprogrammerwrites.eu/?p=2861", "published_at": "2020-06-28T15:14:35+00:00" }, { "id": "01a0d548-3972-7306-a489-6a2ebbcf665f", "title": "SQL for Recursive Generation of Item Sequences", "url": "https://aprogrammerwrites.eu/?p=2845", "published_at": "2020-06-20T18:34:17+00:00" }, { "id": "01a0d548-3972-7306-a489-6a2ebc206909", "title": "Creating Open Source Projects for Database Code – Ireland Oracle User Group Conference 2020", "url": "https://aprogrammerwrites.eu/?p=2728", "published_at": "2020-02-23T16:24:25+00:00" }, { "id": "01a0d548-3972-7306-a489-6a2ebc5b1506", "title": "Analytic and Recursive SQL by Example", "url": "https://aprogrammerwrites.eu/?p=2702", "published_at": "2020-02-14T06:55:53+00:00" }, { "id": "01a0d548-91e3-7204-977d-76eb3b4022b8", "title": "A Note on Running Sums and Products in SQL", "url": "https://aprogrammerwrites.eu/?p=2679", "published_at": "2020-01-19T15:12:49+00:00" }, { "id": "01a0d548-91e3-7204-977d-76eb3c0e8619", "title": "Oracle PL/SQL API Demos Github Module", "url": "https://aprogrammerwrites.eu/?p=2637", "published_at": "2019-11-13T06:14:37+00:00" }, { "id": "01a0d548-91e3-7204-977d-76eb3cf35793", "title": "Headings draft", "url": "https://aprogrammerwrites.eu/?p=2210", "published_at": "2019-11-05T16:35:39+00:00" }, { "id": "01a0d548-cfca-713e-b444-f57b09783e32", "title": "Knapsacks and Numbers", "url": "https://aprogrammerwrites.eu/?p=926", "published_at": "2019-11-05T16:23:26+00:00" }, { "id": "01a0d548-cfca-713e-b444-f57b0a66fbff", "title": "Writing Clean Code in PL/SQL & SQL – Ireland Oracle User Group Conference 2019", "url": "https://aprogrammerwrites.eu/?p=2577", "published_at": "2019-03-19T07:13:36+00:00" }, { "id": "01a0d548-cfca-713e-b444-f57b0ae2e63f", "title": "Extracting Pure Functionality from SQL Queries", "url": "https://aprogrammerwrites.eu/?p=2539", "published_at": "2018-10-29T15:10:36+00:00" }, { "id": "01a0d549-1eba-71ab-9f61-723ac6364a41", "title": "On RDBMS, SQL and the DRY Principle, and Query Networks", "url": "https://aprogrammerwrites.eu/?p=2475", "published_at": "2018-09-02T14:59:10+00:00" }, { "id": "01a0d549-1ebb-70d4-b7e1-f2b6201c307a", "title": "Database API Viewed As A Mathematical Function: Insights into Testing – OUG Ireland Conference 2018", "url": "https://aprogrammerwrites.eu/?p=2318", "published_at": "2017-12-04T20:03:02+00:00" }, { "id": "01a0d549-1ebb-70d4-b7e1-f2b6207ac15d", "title": "Knapsacks and Networks in SQL", "url": "https://aprogrammerwrites.eu/?p=2232", "published_at": "2017-12-03T16:01:50+00:00" }, { "id": "01a0d549-831d-72ff-8630-b5c9c9666329", "title": "An Odd Performance Problem with Update – Twitter Thread", "url": "https://aprogrammerwrites.eu/?p=2167", "published_at": "2017-10-08T19:44:30+00:00" }, { "id": "01a0d549-831d-72ff-8630-b5c9ca46ac92", "title": "Benchmarking Oracle DML: A Case Study II – Effects of Indexes", "url": "https://aprogrammerwrites.eu/?p=2121", "published_at": "2017-09-24T14:44:33+00:00" }, { "id": "01a0d549-831d-72ff-8630-b5c9cae3271e", "title": "Benchmarking Oracle DML: A Case Study I – Update vs Merge, An Example", "url": "https://aprogrammerwrites.eu/?p=2040", "published_at": "2017-09-24T14:44:21+00:00" }, { "id": "01a0d549-d484-725e-9f97-d867ba4ced36", "title": "Dimensional Performance Benchmarking of SQL – IOUG Presentation", "url": "https://aprogrammerwrites.eu/?p=2012", "published_at": "2017-03-25T08:21:45+00:00" }, { "id": "01a0d549-d484-725e-9f97-d867ba6ed8ce", "title": "Dimensional Benchmarking of String Splitting SQL", "url": "https://aprogrammerwrites.eu/?p=1957", "published_at": "2017-03-12T15:39:54+00:00" }, { "id": "01a0d549-d484-725e-9f97-d867bb4a7d9c", "title": "Benchmarking of Hash Join Options in SQL for Fixed-Depth Hierarchies", "url": "https://aprogrammerwrites.eu/?p=1950", "published_at": "2017-03-05T18:28:40+00:00" }, { "id": "01a0d54a-42b8-736a-8938-1edcebf6fde1", "title": "Dimensional Benchmarking of SQL for Fixed-Depth Hierarchies", "url": "https://aprogrammerwrites.eu/?p=1937", "published_at": "2017-03-05T16:22:26+00:00" }, { "id": "01a0d54a-42b8-736a-8938-1edcec6a40e9", "title": "Dimensional Benchmarking of Bracket Parsing SQL", "url": "https://aprogrammerwrites.eu/?p=1913", "published_at": "2017-02-05T18:05:52+00:00" }, { "id": "01a0d54a-42b8-736a-8938-1edced235b7d", "title": "Dimensional Benchmarking of General SQL Bursting Problems", "url": "https://aprogrammerwrites.eu/?p=1872", "published_at": "2016-11-26T09:11:53+00:00" }, { "id": "01a0d54d-73b3-7044-8cd2-1f3ab9a1cff0", "title": "Oracle and JUnit Data Driven Testing: An Example", "url": "https://aprogrammerwrites.eu/?p=1860", "published_at": "2016-11-13T13:07:29+00:00" }, { "id": "01a0d54d-73b3-7044-8cd2-1f3aba59e668", "title": "Dimensional Benchmarking of Oracle v10-v12 Queries for SQL Bursting Problems", "url": "https://aprogrammerwrites.eu/?p=1836", "published_at": "2016-11-06T17:23:40+00:00" }, { "id": "01a0d54d-73b3-7044-8cd2-1f3aba6e01d4", "title": "A Framework for Dimensional Benchmarking of SQL Query Performance", "url": "https://aprogrammerwrites.eu/?p=1833", "published_at": "2016-11-06T17:20:05+00:00" }, { "id": "01a0d54f-86f2-71a2-b1b1-c9a05e6e727a", "title": "Design Patterns for Database API Testing 4: REF Cursor Getter", "url": "https://aprogrammerwrites.eu/?p=1808", "published_at": "2016-10-01T08:46:23+00:00" }, { "id": "01a0d54f-86f2-71a2-b1b1-c9a05f074845", "title": "Design Patterns for Database API Testing 3: Batch Loading of Flat Files", "url": "https://aprogrammerwrites.eu/?p=1791", "published_at": "2016-09-24T08:16:52+00:00" }, { "id": "01a0d54f-86f2-71a2-b1b1-c9a05fb33159", "title": "A Utility for Reading REF Cursors into a List of Delimited Strings", "url": "https://aprogrammerwrites.eu/?p=1777", "published_at": "2016-08-09T19:35:25+00:00" }, { "id": "01a0d550-c4dc-71a6-8440-9f72f6f6f994", "title": "A Note on Dependencies and Database Unit Testing", "url": "https://aprogrammerwrites.eu/?p=1769", "published_at": "2016-08-06T08:03:17+00:00" }, { "id": "01a0d550-c4dc-71a6-8440-9f72f72c0c96", "title": "A Note on Oracle Join Orders and Hints", "url": "https://aprogrammerwrites.eu/?p=1758", "published_at": "2016-07-17T14:41:25+00:00" }, { "id": "01a0d550-c4dc-71a6-8440-9f72f7e3d7b1", "title": "TRAPIT – TRansactional API Testing in Oracle", "url": "https://aprogrammerwrites.eu/?p=1723", "published_at": "2016-06-25T15:24:37+00:00" }, { "id": "01a0d551-7033-7191-986d-6b4a7a6d028f", "title": "Design Patterns for Database API Testing 2: Views 2 – Code", "url": "https://aprogrammerwrites.eu/?p=1691", "published_at": "2016-05-21T12:44:13+00:00" }, { "id": "01a0d551-7033-7191-986d-6b4a7b1adf30", "title": "Design Patterns for Database API Testing 2: Views 1 – Design", "url": "https://aprogrammerwrites.eu/?p=1689", "published_at": "2016-05-21T12:42:37+00:00" }, { "id": "01a0d551-7033-7191-986d-6b4a7b7f1812", "title": "A Template Script for JDBC Calling of Oracle Procedures with Object Array Parameters", "url": "https://aprogrammerwrites.eu/?p=1676", "published_at": "2016-05-14T07:18:42+00:00" }, { "id": "01a0d551-cae2-719a-bef6-8389041004b5", "title": "Design Patterns for Database API Testing 1: Web Service Saving 1 – Design", "url": "https://aprogrammerwrites.eu/?p=1614", "published_at": "2016-05-08T17:07:07+00:00" }, { "id": "01a0d551-cae2-719a-bef6-8389044756a5", "title": "Design Patterns for Database API Testing 1: Web Service Saving 2 – Code", "url": "https://aprogrammerwrites.eu/?p=1616", "published_at": "2016-05-08T17:03:06+00:00" }, { "id": "01a0d551-cae2-719a-bef6-8389053f911d", "title": "Code Timing and Object Orientation and Zombies", "url": "https://aprogrammerwrites.eu/?p=1632", "published_at": "2016-05-07T14:34:01+00:00" }, { "id": "01a0d552-0a9c-727a-96f0-aebcd07787e8", "title": "Oracle Unit Testing with utPLSQL", "url": "https://aprogrammerwrites.eu/?p=1545", "published_at": "2015-10-10T13:12:38+00:00" }, { "id": "01a0d552-0a9c-727a-96f0-aebcd114b225", "title": "Recursive SQL for Network Analysis, and Duality", "url": "https://aprogrammerwrites.eu/?p=1509", "published_at": "2015-09-02T07:47:13+00:00" }, { "id": "01a0d552-0a9c-727a-96f0-aebcd1fe77dc", "title": "SQL Developer: Importing Unit Test Repository via Data Modeler", "url": "https://aprogrammerwrites.eu/?p=1460", "published_at": "2015-07-11T13:47:37+00:00" }, { "id": "01a0d552-59bb-731b-bcfa-648c8b525354", "title": "PL/SQL Pipelined Function for Network Analysis", "url": "https://aprogrammerwrites.eu/?p=1426", "published_at": "2015-05-10T17:41:00+00:00" }, { "id": "01a0d552-59bb-731b-bcfa-648c8bec0496", "title": "SQL for Shortest Path Problems 2: A Branch and Bound Approach", "url": "https://aprogrammerwrites.eu/?p=1415", "published_at": "2015-05-04T17:42:55+00:00" }, { "id": "01a0d552-59bb-731b-bcfa-648c8c678d7d", "title": "SQL for Shortest Path Problems", "url": "https://aprogrammerwrites.eu/?p=1391", "published_at": "2015-04-19T16:43:21+00:00" }, { "id": "01a0d552-9d53-702d-b9ae-e2b0d4d0535d", "title": "Unix Snippets for Handling Duplicate Keys in Delimited Input Files", "url": "https://aprogrammerwrites.eu/?p=1348", "published_at": "2014-11-30T17:01:50+00:00" }, { "id": "01a0d552-9d53-702d-b9ae-e2b0d56d8b02", "title": "A Generic Unix Script for Uploading eBusiness Concurrent Programs", "url": "https://aprogrammerwrites.eu/?p=1282", "published_at": "2014-09-28T16:15:43+00:00" }, { "id": "01a0d552-9d53-702d-b9ae-e2b0d6681bcb", "title": "Design Patterns for Database Reports with XML Publisher and Email Bursting", "url": "https://aprogrammerwrites.eu/?p=1181", "published_at": "2014-09-20T14:57:20+00:00" }, { "id": "01a0d552-d6af-722e-879e-1e37b6738707", "title": "Query Query Query", "url": "https://aprogrammerwrites.eu/?p=1173", "published_at": "2014-09-03T15:45:06+00:00" }, { "id": "01a0d552-d6af-722e-879e-1e37b737adb5", "title": "A Design Pattern for Oracle eBusiness Audit Trail Reports with XML Publisher", "url": "https://aprogrammerwrites.eu/?p=1130", "published_at": "2014-08-31T13:48:18+00:00" }, { "id": "01a0d552-d6af-722e-879e-1e37b7bf2c06", "title": "NoCOUG SQL Challenge 2014 Illustrated", "url": "https://aprogrammerwrites.eu/?p=1118", "published_at": "2014-08-25T11:30:34+00:00" }, { "id": "01a0d553-0c5b-71ed-8d3f-c867ae8335c5", "title": "Low-Hanging Fruit: The Classic Performance Tuning Anti-pattern", "url": "https://aprogrammerwrites.eu/?p=1095", "published_at": "2014-07-28T19:00:58+00:00" }, { "id": "01a0d553-0c5b-71ed-8d3f-c867af5bb97c", "title": "Brendan’s 2-Page Oracle Programming Standards", "url": "https://aprogrammerwrites.eu/?p=1055", "published_at": "2014-05-24T14:56:57+00:00" }, { "id": "01a0d553-0c5b-71ed-8d3f-c867b000288b", "title": "SQL for Continuum and Contiguity Grouping", "url": "https://aprogrammerwrites.eu/?p=187", "published_at": "2013-11-16T15:30:01+00:00" }, { "id": "01a0d553-44ef-710a-beb3-375470bbf65d", "title": "Messages from Outer Space", "url": "https://aprogrammerwrites.eu/?p=954", "published_at": "2013-10-15T20:23:33+00:00" }, { "id": "01a0d553-44ef-710a-beb3-3754718b9798", "title": "SQL and Modularity: Patterns, Anti-Patterns and the Kitchen Sink", "url": "https://aprogrammerwrites.eu/?p=931", "published_at": "2013-09-08T15:44:13+00:00" }, { "id": "01a0d553-44ef-710a-beb3-3754723a2c27", "title": "SQL for Length-Controlled List Aggregation", "url": "https://aprogrammerwrites.eu/?p=913", "published_at": "2013-08-17T08:15:15+00:00" }, { "id": "01a0d558-1fa7-7139-85dd-1955a872b81a", "title": "SQL for the Travelling Salesman Problem", "url": "https://aprogrammerwrites.eu/?p=896", "published_at": "2013-07-14T16:56:00+00:00" }, { "id": "01a0d558-1fa7-7139-85dd-1955a8a998c3", "title": "SQL for the Fantasy Football Knapsack Problem", "url": "https://aprogrammerwrites.eu/?p=878", "published_at": "2013-06-22T13:58:16+00:00" }, { "id": "01a0d558-1fa7-7139-85dd-1955a99bb82f", "title": "SQL for the Balanced Number Partitioning Problem", "url": "https://aprogrammerwrites.eu/?p=803", "published_at": "2013-05-25T14:46:56+00:00" }, { "id": "01a0d559-6802-7202-8d24-d9b5443bbb39", "title": "Design Patterns for Extracting Relational Data from XML", "url": "https://aprogrammerwrites.eu/?p=783", "published_at": "2013-04-21T17:11:14+00:00" }, { "id": "01a0d559-6802-7202-8d24-d9b544c99465", "title": "SQL for Network Grouping", "url": "https://aprogrammerwrites.eu/?p=762", "published_at": "2013-03-23T15:37:22+00:00" }, { "id": "01a0d559-6802-7202-8d24-d9b544ca3b88", "title": "PL/SQL Profiling 1 – Overview", "url": "https://aprogrammerwrites.eu/?p=703", "published_at": "2013-03-05T11:02:09+00:00" }, { "id": "01a0d55a-448d-725a-a48f-4c53d24f85cd", "title": "An SQL Solution for the Multiple Knapsack Problem (SKP-m)", "url": "https://aprogrammerwrites.eu/?p=635", "published_at": "2013-01-20T19:16:09+00:00" }, { "id": "01a0d55a-448d-725a-a48f-4c53d32983c3", "title": "A Simple SQL Solution for the Knapsack Problem (SKP-1)", "url": "https://aprogrammerwrites.eu/?p=560", "published_at": "2013-01-06T18:33:30+00:00" }, { "id": "01a0d55a-448d-725a-a48f-4c53d33dfac3", "title": "Master-Detail Transaction Reconciliation in SQL (MDTM3)", "url": "https://aprogrammerwrites.eu/?p=515", "published_at": "2012-10-26T16:50:33+00:00" }, { "id": "01a0d55a-8e9c-709a-9cfb-bf46a03ee8fc", "title": "Holographic Set Matching in SQL (MDTM2)", "url": "https://aprogrammerwrites.eu/?p=488", "published_at": "2012-10-12T15:25:57+00:00" }, { "id": "01a0d55a-8e9c-709a-9cfb-bf46a0a169bf", "title": "Master-Detail Transaction Matching in SQL (MDTM1)", "url": "https://aprogrammerwrites.eu/?p=268", "published_at": "2012-10-10T16:25:23+00:00" }, { "id": "01a0d55a-8e9c-709a-9cfb-bf46a1869a5f", "title": "List Aggregation in Oracle – Comparing Three Methods", "url": "https://aprogrammerwrites.eu/?p=346", "published_at": "2012-09-30T17:30:20+00:00" }, { "id": "01a0d55a-cc34-70c2-9ef2-c9987f97944b", "title": "Grouping by Unique Subsequences in SQL", "url": "https://aprogrammerwrites.eu/?p=279", "published_at": "2012-09-08T13:03:29+00:00" }, { "id": "01a0d55a-cc34-70c2-9ef2-c998808ff5e2", "title": "Query Structure Diagramming", "url": "https://aprogrammerwrites.eu/?p=206", "published_at": "2012-08-11T09:17:54+00:00" }, { "id": "01a0d55a-cc34-70c2-9ef2-c998816322c2", "title": "A Layered Approach To Processing XML Web Services", "url": "https://aprogrammerwrites.eu/?p=131", "published_at": "2012-02-05T11:23:30+00:00" }, { "id": "01a0d55b-08ec-71c8-b4b7-1d05533d0d5e", "title": "Data Modelling of XML SOAP Documents", "url": "https://aprogrammerwrites.eu/?p=96", "published_at": "2012-01-29T10:29:36+00:00" }, { "id": "01a0d55b-08ec-71c8-b4b7-1d055376221e", "title": "Data Structure Diagramming", "url": "https://aprogrammerwrites.eu/?p=63", "published_at": "2012-01-21T15:51:40+00:00" }, { "id": "01a0d55b-08ec-71c8-b4b7-1d0553ee61e2", "title": "Case Expressions and Ignoring Nulls in Analytic Functions", "url": "https://aprogrammerwrites.eu/?p=14", "published_at": "2012-01-15T16:05:29+00:00" }, { "id": "01a0d55b-53b2-7299-a5d0-9653d43cd566", "title": "Hello world!", "url": "https://aprogrammerwrites.eu/?p=1", "published_at": "2012-01-08T17:00:40+00:00" } ] posts Claim your blog
Back to aprogrammerwrites.eu
Blog · corpus.blog/blogs/aprogrammerwrites.eu/posts

aprogrammerwrites.eu

aprogrammerwrites.eu

2025

Coupons, Caps and Functions – Introoriginal ↗
30 Jun 2025

2024

Optimization Problems with Items and Categories in Oracle – Introoriginal ↗
26 Aug 2024

2023

Oracle User Group Ireland Presentationsoriginal ↗
22 Oct 2023
The Math Function Unit Testing Design Pattern – Introductionoriginal ↗
5 Jun 2023
A Note on Updates to Unit Testing Projectsoriginal ↗
7 May 2023

2022

Analysing Performance of Algorithmic SQL and PL/SQL – Ireland Oracle User Group Conference 2022original ↗
21 Aug 2022
Shortest Path Analysis of Large Networks by SQL and PL/SQL – Introoriginal ↗
12 Aug 2022

2021

Unit Testing, Scenarios and Categories: The SCAN Method – Introoriginal ↗
17 Oct 2021
SQL for Period Aggregate Reportingoriginal ↗
28 Feb 2021

2020

PL/SQL Profiling 4: Custom Code Timingoriginal ↗
28 Jun 2020
PL/SQL Profiling 3: Flat Profileroriginal ↗
28 Jun 2020
PL/SQL Profiling 2: Hierarchical Profileroriginal ↗
28 Jun 2020
SQL for Recursive Generation of Item Sequencesoriginal ↗
20 Jun 2020
Creating Open Source Projects for Database Code – Ireland Oracle User Group Conference 2020original ↗
23 Feb 2020
Analytic and Recursive SQL by Exampleoriginal ↗
14 Feb 2020
A Note on Running Sums and Products in SQLoriginal ↗
19 Jan 2020

2019

Oracle PL/SQL API Demos Github Moduleoriginal ↗
13 Nov 2019
Headings draftoriginal ↗
5 Nov 2019
Knapsacks and Numbersoriginal ↗
5 Nov 2019
Writing Clean Code in PL/SQL & SQL – Ireland Oracle User Group Conference 2019original ↗
19 Mar 2019

2018

Extracting Pure Functionality from SQL Queriesoriginal ↗
29 Oct 2018
On RDBMS, SQL and the DRY Principle, and Query Networksoriginal ↗
2 Sept 2018

2017

Database API Viewed As A Mathematical Function: Insights into Testing – OUG Ireland Conference 2018original ↗
4 Dec 2017
Knapsacks and Networks in SQLoriginal ↗
3 Dec 2017
An Odd Performance Problem with Update – Twitter Threadoriginal ↗
8 Oct 2017
Benchmarking Oracle DML: A Case Study II – Effects of Indexesoriginal ↗
24 Sept 2017
Benchmarking Oracle DML: A Case Study I – Update vs Merge, An Exampleoriginal ↗
24 Sept 2017
Dimensional Performance Benchmarking of SQL – IOUG Presentationoriginal ↗
25 Mar 2017
Dimensional Benchmarking of String Splitting SQLoriginal ↗
12 Mar 2017
Benchmarking of Hash Join Options in SQL for Fixed-Depth Hierarchiesoriginal ↗
5 Mar 2017
Dimensional Benchmarking of SQL for Fixed-Depth Hierarchiesoriginal ↗
5 Mar 2017
Dimensional Benchmarking of Bracket Parsing SQLoriginal ↗
5 Feb 2017

2016

Dimensional Benchmarking of General SQL Bursting Problemsoriginal ↗
26 Nov 2016
Oracle and JUnit Data Driven Testing: An Exampleoriginal ↗
13 Nov 2016
Dimensional Benchmarking of Oracle v10-v12 Queries for SQL Bursting Problemsoriginal ↗
6 Nov 2016
A Framework for Dimensional Benchmarking of SQL Query Performanceoriginal ↗
6 Nov 2016
Design Patterns for Database API Testing 4: REF Cursor Getteroriginal ↗
1 Oct 2016
Design Patterns for Database API Testing 3: Batch Loading of Flat Filesoriginal ↗
24 Sept 2016
A Utility for Reading REF Cursors into a List of Delimited Stringsoriginal ↗
9 Aug 2016
A Note on Dependencies and Database Unit Testingoriginal ↗
6 Aug 2016
A Note on Oracle Join Orders and Hintsoriginal ↗
17 Jul 2016
TRAPIT – TRansactional API Testing in Oracleoriginal ↗
25 Jun 2016
Design Patterns for Database API Testing 2: Views 2 – Codeoriginal ↗
21 May 2016
Design Patterns for Database API Testing 2: Views 1 – Designoriginal ↗
21 May 2016
A Template Script for JDBC Calling of Oracle Procedures with Object Array Parametersoriginal ↗
14 May 2016
Design Patterns for Database API Testing 1: Web Service Saving 1 – Designoriginal ↗
8 May 2016
Design Patterns for Database API Testing 1: Web Service Saving 2 – Codeoriginal ↗
8 May 2016
Code Timing and Object Orientation and Zombiesoriginal ↗
7 May 2016

2015

Oracle Unit Testing with utPLSQLoriginal ↗
10 Oct 2015
Recursive SQL for Network Analysis, and Dualityoriginal ↗
2 Sept 2015
SQL Developer: Importing Unit Test Repository via Data Modeleroriginal ↗
11 Jul 2015
PL/SQL Pipelined Function for Network Analysisoriginal ↗
10 May 2015
SQL for Shortest Path Problems 2: A Branch and Bound Approachoriginal ↗
4 May 2015
SQL for Shortest Path Problemsoriginal ↗
19 Apr 2015

2014

Unix Snippets for Handling Duplicate Keys in Delimited Input Filesoriginal ↗
30 Nov 2014
A Generic Unix Script for Uploading eBusiness Concurrent Programsoriginal ↗
28 Sept 2014
Design Patterns for Database Reports with XML Publisher and Email Burstingoriginal ↗
20 Sept 2014
Query Query Queryoriginal ↗
3 Sept 2014
A Design Pattern for Oracle eBusiness Audit Trail Reports with XML Publisheroriginal ↗
31 Aug 2014
NoCOUG SQL Challenge 2014 Illustratedoriginal ↗
25 Aug 2014
Low-Hanging Fruit: The Classic Performance Tuning Anti-patternoriginal ↗
28 Jul 2014
Brendan’s 2-Page Oracle Programming Standardsoriginal ↗
24 May 2014

2013

SQL for Continuum and Contiguity Groupingoriginal ↗
16 Nov 2013
Messages from Outer Spaceoriginal ↗
15 Oct 2013
SQL and Modularity: Patterns, Anti-Patterns and the Kitchen Sinkoriginal ↗
8 Sept 2013
SQL for Length-Controlled List Aggregationoriginal ↗
17 Aug 2013
SQL for the Travelling Salesman Problemoriginal ↗
14 Jul 2013
SQL for the Fantasy Football Knapsack Problemoriginal ↗
22 Jun 2013
SQL for the Balanced Number Partitioning Problemoriginal ↗
25 May 2013
Design Patterns for Extracting Relational Data from XMLoriginal ↗
21 Apr 2013
SQL for Network Groupingoriginal ↗
23 Mar 2013
PL/SQL Profiling 1 – Overvieworiginal ↗
5 Mar 2013
An SQL Solution for the Multiple Knapsack Problem (SKP-m)original ↗
20 Jan 2013
A Simple SQL Solution for the Knapsack Problem (SKP-1)original ↗
6 Jan 2013

2012

Master-Detail Transaction Reconciliation in SQL (MDTM3)original ↗
26 Oct 2012
Holographic Set Matching in SQL (MDTM2)original ↗
12 Oct 2012
Master-Detail Transaction Matching in SQL (MDTM1)original ↗
10 Oct 2012
List Aggregation in Oracle – Comparing Three Methodsoriginal ↗
30 Sept 2012
Grouping by Unique Subsequences in SQLoriginal ↗
8 Sept 2012
Query Structure Diagrammingoriginal ↗
11 Aug 2012
A Layered Approach To Processing XML Web Servicesoriginal ↗
5 Feb 2012
Data Modelling of XML SOAP Documentsoriginal ↗
29 Jan 2012
Data Structure Diagrammingoriginal ↗
21 Jan 2012
Case Expressions and Ignoring Nulls in Analytic Functionsoriginal ↗
15 Jan 2012
Hello world!original ↗
8 Jan 2012