Skip to primary content

Skip to secondary content

A Programmer Writes… (Brendan's Blog)

Search

Main menu

Home
About
Scribd Articles
Walking to Work

Tag Archives: tdd

Oracle Unit Testing with utPLSQL

Posted on October 10, 2015 by BrendanP

2

Some slides I did…

Oracle Unit Testing with utPLSQL from Brendan Furey

Posted in Oracle, PL/SQL, SQL, Testing | Tagged agile, Oracle, PL/SQL, tdd, unit test, utplsql | 2 Replies

My Blog Posts

Knapsacks and Networks in SQL
Messages from Outer Space
On RDBMS, SQL and the DRY Principle, and Query Networks
Oracle PL/SQL API Demos Github Module
Shortest Path Analysis of Large Networks by SQL and PL/SQL – Intro

My Design Posts

A Layered Approach To Processing XML Web Services
Brendan's 2-Page Oracle Programming Standards
Data Modelling of XML SOAP Documents
Data Structure Diagramming
NoCOUG SQL Challenge 2014 Illustrated
Query Query Query
Query Structure Diagramming
SQL and Modularity: Patterns, Anti-Patterns and the Kitchen Sink
SQL Developer: Importing Unit Test Repository via Data Modeler

My Functional Testing Posts

A Note on Dependencies and Database Unit Testing
A Template Script for JDBC Integration Testing of Oracle Procedures
Design Patterns for Database API Testing 1: Web Service Saving 1 – Design
Design Patterns for Database API Testing 1: Web Service Saving 2 – Code
Design Patterns for Database API Testing 2: Views 1 – Design
Design Patterns for Database API Testing 2: Views 2 – Code
Design Patterns for Database API Testing 3: Batch Loading of Flat Files
Design Patterns for Database API Testing 4: REF Cursor Getter
Extracting Pure Functionality from SQL Queries
Oracle and JUnit Data Driven Testing: An Example
TRAPIT – TRansactional API Testing in Oracle
Unit Testing, Scenarios and Categories: The SCAN Method – Intro

My Oracle eBusiness Posts

A Design Pattern for Oracle eBusiness Audit Trail Reports with XML Publisher
A Generic Unix Script for Uploading Oracle eBusiness Concurrent Programs
Design Patterns for Database Reports with XML Publisher and Email Bursting

My Other SQL Posts

A Utility for Reading REF Cursors into a List of Delimited Strings
Case Expressions and Ignoring Nulls in Analytic Functions
Design Patterns for Extracting Relational Data from XML
Grouping by Unique Subsequences in SQL
Holographic Set Matching in SQL (MDTM2)
List Aggregation in Oracle – Comparing Three Methods
Master-Detail Transaction Matching in SQL (MDTM1)
Master-Detail Transaction Reconciliation in SQL (MDTM3)
SQL for Continuum and Contiguity Grouping
SQL for Period Aggregate Reporting

My Performance Testing Posts

A Framework for Dimensional Benchmarking of SQL Query Performance
A Note on Oracle Join Orders and Hints
An Odd Performance Problem with Update – Twitter Thread
Benchmarking of Hash Join Options in SQL for Fixed-Depth Hierarchies
Benchmarking Oracle DML: A Case Study I – Update vs Merge, An Example
Benchmarking Oracle DML: A Case Study II – Effects of Indexes
Code Timing and Object Orientation and Zombies
Dimensional Benchmarking of Bracket Parsing SQL
Dimensional Benchmarking of General SQL Bursting Problems
Dimensional Benchmarking of Oracle v10-v12 Queries for SQL Bursting Problems
Dimensional Benchmarking of SQL for Fixed-Depth Hierarchies
Dimensional Benchmarking of String Splitting SQL
Low-Hanging Fruit: The Classic Performance Tuning Anti-pattern
PL/SQL Profiling 1 – Overview
PL/SQL Profiling 2: Hierarchical Profiler
PL/SQL Profiling 3: Flat Profiler
PL/SQL Profiling 4: Custom Code Timing
Shortest Path Analysis of Large Networks by SQL and PL/SQL – Intro

My Presentations

Analysing Performance of Algorithmic SQL and PL/SQL – Ireland Oracle User Group Conference 2022
Creating Open Source Projects for Database Code – Ireland Oracle User Group Conference 2020
Database API Viewed As A Mathematical Function: Insights into Testing – OUG Ireland Conference 2018
Dimensional Performance Benchmarking of SQL – IOUG Presentation
Oracle Unit Testing with utPLSQL
Writing Clean Code in PL/SQL & SQL – Ireland Oracle User Group Conference 2019

My Recursive SQL Posts

A Note on Running Sums and Products in SQL
A Simple SQL Solution for the Knapsack Problem (SKP-1)
An SQL Solution for the Multiple Knapsack Problem (SKP-m)
Analytic and Recursive SQL by Example
PL/SQL Pipelined Function for Network Analysis
Recursive SQL for Network Analysis, and Duality
SQL for Length-Controlled List Aggregation
SQL for Network Grouping
SQL for Shortest Path Problems
SQL for Shortest Path Problems 2: A Branch and Bound Approach
SQL for the Balanced Number Partitioning Problem
SQL for the Fantasy Football Knapsack Problem
SQL for the Travelling Salesman Problem

My Scribd Articles

A Database System High Level Design Template
A Perl Object for Flattened Master-Detail Data in Excel
A Structured Approach to SQL Query Design
An Oracle Network Traversal PL SQL Program
Analysing Unix System Performance with prstat and SQL
Batch Migration and Loading of Oracle FND Data
Code Timing and Object Orientation and Zombies
Forming Range-Based Break Groups With Advanced SQL
IT Project Development To Release Processes
Oracle Applications Extension Installation Template
Oracle Applications FNDLOAD Unix Scripts
Oracle Applications Utility SQL Scripts
Oracle Forms Generic UTP
Oracle Multi-Org – AR and OM Data Structure Changes
SQL Pivot and Prune Queries – Keeping an Eye on Performance
Unit Test Plan Template

My Unix Posts

Unix Snippets for Handling Duplicate Keys in Delimited Input Files

Other Blogs

Stew Ashton's Blog

Get more stuff like this
in your inbox

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

I consent to my submitted data being collected via this form*

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously

Proudly powered by WordPress