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 5, 2019

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

Featuring:

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."

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

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Oracle PL/SQL. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

Your Experts
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.
Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. 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.