Kscope19 Logo-No Location.png

View Printable Version

Testing with utPLSQL—Made Easy with SQL Developer

Session Number: 8100
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Philipp Salvisberg [Senior Principal Consultant - Trivadis]
Time: Jun 25, 2019 (10:00 AM - 11:00 AM)
Room: 619, Level 6

Speaker Bio: Philipp Salvisberg is a senior principal consultant, partner, and member of the boards of directors at Trivadis and an Oracle ACE. He has been focusing on Oracle database-based solutions since 1988, at that time with Oracle Database version 5. Since then, he has been helping customers design, build, and optimize their database-centric solutions, while also teaching application development topics and speaking at conferences.

Philipp has a soft spot for doing as much as possible in a single SQL statement and is interested in pretty much everything that allows him to use the database as efficiently as possible. He likes to design model-driven software solutions using domain-specific languages, while getting the most out of the underlying technologies.

Technologies or Products Used: Oracle Database, utPLSQL, PL/SQL, SQL Developer

Session Summary for Attendees:  The testing framework utPLSQL, originally developed by Steven Feuerstein, was completely rewritten in version three. It is based on concepts used in JUnit. This facilitates both the programming of tests and the integration into existing CI environments with Jenkins and SonarQube. An important aspect of testing are asserts to compare the expected result with the actual one. utPLSQL provides very good and complete support in this area, so that, for example, query results can be compared very easily. The first step is always the hardest. Therefore, after a short introduction I will show you step by step how to add tests to an existing PL/SQL project and how the Oracle SQL Developer simplifies working with utPLSQL.

Be sure to keep your user profile up to date! Click here to update now.