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.
Want to sponsor? Contact us to find out more.