BUG in INSERT … SELECT with nested objects I came across a very nasty bug in Oracle SQL engine while working on some new code. It took me a while to figure out what the problem is as the SQL code I was working on was acting weird. The work was related to refactoring and consolidating an existing code. As part of the… Read More
Test Driven Development in PLSQL with utPLSQL v3 – intro Foreword The biggest challenge around unit testing is to make it work for you (as an engineer), not against you. Many developers struggle, when writing unit tests. This is mainly due to the fact that while we are educated in design and implementation of database software, we are not mentored on unit testing. The struggle leads… Read More