About Oracle

This is the first post about implementing business rules in an Oracle database. In the previous millenium I've implemented them a lot us...

If you use SYSDATE or SYSTIMESTAMP multiple times in a query that takes some time, will you see different times? No, because queries are rea...

For some time now, I have recommended to use dbms_lock.request when implementing business rules correctly. In short, the idea behind it is t...

Just noticed that Christian Antognini started blogging a couple of weeks ago. I added the blog to my reader, hoping for more interesting po...

Today I will give an in-house knowledge session called "Do more with SQL". I want to share my knowledge about this topic, because ...

There are lots of ways to do string aggregation. My favourite one is by using the model clause. Although you have to be aware of the increas...

In a earlier blogpost of mine , I talked about Toon Koppelaars' new product called RuleGen . I promised to do some testing about the per...