| layout | page |
|---|---|
| title | Resources |
| permalink | /resources/ |
| menuInclude | true |
Do you know about videos, articles, blogs or code examples that are missing here? Please let us know!
- 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)
- utPLSQL’s Suite Hierarchy in action (by Samuel Nitsche)
Example of the%suitepathannotation 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%contextannotation
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 (by Jacek Gebal)
Comparison between utPLSQL v2'sutassert.eqtableand v3'sut.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 withselect from dualexpectations - 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
- 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
- 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