Resources

Do you know about videos, articles, blogs or code examples that are missing here? Please let us know!

Framework

• Latest documentation

Overview

• UKOUG Testing PLSQL APIs with utPLSQL v3 Webinar (by Jacek Gebal)
  Comprehensive webinar about utPLSQL by Jacek Gebal. The definitive guide to why and how to test PL/SQL with utPLSQL
• utPLSQL 3.0 - How to have your cake and eat it (by Mike Smithers)
  Complete introduction to utPLSQL 3.0, covering installation, comprehensive example application, transaction challenges and even code coverage
• Strongholds of Confidence: Self-Testing your Database (by Samuel Nitsche)
  Plea to start creating meaningful, automated self-tests and why. Finishes with a concrete utPLSQL example
• Test Driven Development in PLSQL with utPLSQL v3 – intro (by Jacek Gebal)
  Addresses some major struggles of developers who start with unit-testing and also gives a brief intro into Test-Driven-Development
• Testing PL/SQL in your Ci/Cd pipeline with utPLSQL (by Blaine Carter) Blaine demonstrates running utPLSQL unit tests in Oracle Developer Cloud and publishing test results.
• Extending Oracle Database DevOps with Automated PL/SQL Unit Testing (by Shay Shmeltzer) Overview of running utPLSQL unit tests within Oracle Developer Cloud
• DevOps Around Autonomous Data Warehouse (Oracle) A short overview of an architecture proposed for Database Software Delivery LifeCycle with automated testing and static code analysis
• Oracle Developers Office Hours - Real World Testing of PL/SQL Code (hosted by Steven Feuerstein) Panel webinar with: Jasmin Fluri, Deepthi Bandari, Swathi Ambati & Maik Becker, Patrick Barel & Samuel Nitsche
• Oracle Groundbreakers - Testing with utPLSQL (by Philipp Salvisberg) Presentation on 28th October 2020 at Oracle Groundbreakers APAC Virtual Tour
• Oracle Developers Office Hours - Testing with utPLSQL (hosted by Connor McDonald) Live coding and testing session with Samuel Nitsche and Jacek Gebal
• Testing in the Imperial Database (by Samuel Nitsche) Talk from SAST Q4 Digital Testing conference
• Testing With utPLSQL – Made Easy With SQL Developer (by Philipp Salvisberg)
• Database Development Champions - Programming With utPLSQL – This Is the Way (by Philipp Salvisberg)

Structuring Tests

• utPLSQL’s Suite Hierarchy in action (by Samuel Nitsche)
  Example of the %suitepath annotation and utPLSQL hierarchies
• Narrate Star Wars Movies with utPLSQL annotations (by Samuel Nitsche)
  Example how to use the different annotations that allow to structure tests (%before, %after, %context)
• Testing the Deathstar security with utPLSQL contexts (by Samuel Nitsche)
  Example how to use the %context annotation

Cursor Comparison

• What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 (by Jacek Gebal)
  Comparison between utPLSQL v2’s utassert.eqtable and v3’s ut.expect(sys_refcursor).to_equal(sys_refcursor) approach.
• Unit-Tests for Primary/Secondary Lookup with Cursor Comparison (by Samuel Nitsche)
  Example how to use cursor comparison with select from dual expectations
• utPLSQL Cursor Comparison with user-defined Types (by Samuel Nitsche)
  Example how to use cursor comparison with expectations created via user-defined types
• Test updatable views with utPLSQL Cursors (by Samuel Nitsche)
  Example how to easily test the updatability of a view with cursor comparison

Code Talks

• 2017 CodeTalk Series: Unit Testing PL SQL Code in the Real World
• 2018 CodeTalk Series: Practical Advice for Taking Your PL SQL Testing to the Next Level

Tools

utPLSQL - SQLDeveloper extension

• Running utPLSQL Tests in SQL Developer (by Philipp Salvisberg)
  Detailed explanation how to install and use the utPLSQL-Plugin for SQLDeveloper
• utPLSQL for SQL Developer 1.2 – What’s New? (by Philipp Salvisberg)
• Documentation
• Downloads

utPLSQL Command-line interface

• Documentation
• Downloads

utPLSQL PLSQL-Developer plugin

• Documentation
• Download

Maven-Plugin

• Documentation