UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part two (setup and basic reporting) 2015-06-24 | 5 Comments In my previous post I have described the conceptual differences between UTPLSQL and ruby-plsql frameworks for unit testing of Oracle database code. I have used a message_api package and unit tests for that API using both frameworks as an example. In this post I will focus on getting the tests to run and the feedback… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part one 2015-06-14 | 3 Comments 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 MERGE operation – get number of rows inserted / updated deleted 2015-06-13 | Leave a comment 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
Test Drive your Oracle database. Yes, it’s doable. And it’s fun! 2015-05-04 | 3 Comments Foreword Over a month ago I’ve made a big decision and a shift in my life. I’ve decided to move to Ireland and start a new career there. Since I moved, I have significant amount of free time, as I no longer waste 3 hours each day on commuting. Also, since my wife still leaves… Read More
PL/SQL performance freak series – alternatives to PL/SQL function calls from SQL 2014-06-03 | Leave a comment Last week I revealed the numbers standing behind the overhead of calling a Pl/SQL function from within an SQL statement. I’ve left two questions open: – Is it always a performance issue, when you call a PL/SQL function from a SQL statement? – What can be done to maintain the function encapsulation (have the code DRY) and… Read More