Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

November 05, 2019

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Real World Testing Your PL/SQL Code
No application will ever have zero bugs, but you sure want to keep them to a minimum. The best way to do this is to implement automated regression tests of your code, but "best" as usual does not equate to "easiest." Building and managing tests can be a big challenge, so in this Office Hours session, we will hear from developers who are doing just that. Learn from your peers about the obstacles they faced and how they overcame them. Bring your own stories and your questions, and let's all work together on improving our code quality!

Video Highlights:

01:43 - Testing challenges and introducing the speakers
04:51 - Jasmin Fluri on lessons from two projects with automated testing
16:44 - Deepthi Bandari on the joys and challenges of automated testing
24:57 - Swathi Ambati and Maik Becker - run and monitor utPLSQL tests with APEX
36:38 - Patrick Barel and SQL Developer unit testing
46:50 - Samuel Nitsche on how to use testing to explore unknown functionality in a legacy app


Jasmin Fluri: an independent consultant at Schaltstelle GmbH and lectures on software engineering and code review at the University of Applied Sciences North-western Switzerland. Her focus as a database developer and DevOps engineer lies on continuous integration and delivery pipelines, automation of recurring tasks, PL/SQL development, data engineering, and data warehousing.

Maik Becker and Swathi Ambati of Triology: Swathi (@smreddy19) is an Oracle Database and Application Developer. Recently she started developing Database Applications using Oracle APEX and she is always eager to learn and implement new ideas to do her work more productively and innovatively. Maik (@beckerman_maik) is responsible for Oracle Database Development and Application Express at TRIOLOGY. With his passion for Oracle APEX he is always focused on the business cases of his customers.

Deepthi Bandari, a senior software engineer at Fidelity Investments, will share some of her joys and challenges when it comes to unit testing, test automation and promoting engineering excellent.

Patrick Barel is a PL/SQL Developer for Qualog in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins for PL/SQL Developer, publishes articles on his own blog and is an Oracle ACE Director. Patrick is going to show what he's been doing with SQL Developer unit testing features and SQLcl commands.

Samuel Nitsche of the utPLSQL team, a curiosity-driven software-developer with nearly 20 years of development experience, working at Smart Enterprise Solutions GmbH, a small software company in southern Germany. In his free time he writes regularly about database development and testing topics, presents at meetups and conferences (gladly in sith-robe) and works on making the framework "even more awesome."

Your Experts

    Steven Feuerstein

    Steven Feuerstein   

    Steven Feuerstein is a Senior Advisor at Insum Solutions (, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!
    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.