Are you using SQL Developer for Oracle DB development? Have you ever thought about using utPLSQL to test your code? I will explain the basics and show you how to add tests to an existing PL/SQL project. We start with an empty worksheet. 100% live coding. Are you ready to become an utPLSQL fan?
The testing framework utPLSQL, originally developed by Steven Feuerstein, was completely rewritten in version 3. 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 result can be compared very easily. The first step is always the hardest. Therefore, after a short introduction I will show you how to add tests step by step to an existing PL/SQL project and how the Oracle SQL Developer simplifies working with utPLSQL.
