I my previous posts I have described some differences between UTPLSQL and ruby-plsql. This time I want to focus on automating the test execution with each of those frameworks using Jenkins Continuous Integration. The reasons for continuous testing Some of the problems that I often see in projects is that developers don’t fully acknowledge the… Read More


UTPLSQL_vs_RSpec

Foreword Unit Testing is around for quite a while. Since it started to become more and more popular, quite a few tools became available for Oracle database to allow unit testing of the database. There are the UI based tools like Quest Code Tester (now Dell Code Tester for Oracle), Oracle SQL Developer unit testing.… Read More


Oracle database does notĀ support ability to obtain number of rows inserted/updated/deleted by a merge operation. The only value you can obtain is the total number of rows affected by merge operation. Consider the following example. Setup. Code: All that you can get is the overall number of rows processed by merge statement. So I’ve created… Read More