UTPLSQL vs. ruby-plsql – Running Oracle unit tests on Jenkins CI 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
Oracle MERGE operation – get number of rows inserted / updated deleted 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