-
Apex 4.0 moves to apex.oracle.com
In case you haven’t noticed already, David Peake’s blog just announced that APEX 4.0 moves one step closer to become available for download. It is now the release that powers apex.oracle.com. http://dpeake.blogspot.com/2010/06/apex-40-comes-to-httpapexoraclecom.html This is good news as it shows that the release is getting close to be completed. Upgrading apex.oracle.com is usually one of the…
-
The case for CASE
I’ve just uploaded my latest article. This time it is a look at the SQL keyword CASE. It’s power is often not fully appreciated. It is much more flexible and powerful than you may expect from just taking a quick glance in the official documentation. The article is located here. Please post comments and questions…
-
Interested Transaction List
Interested Transaction List is the method through which Oracle keeps track of which transaction has updated which row in a block. I wrote an article about it a while back where I show how the ITL works and how it impacts performance in certain situations. The basis of the article is a page locking scenario…