Is_number

Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006

Domain index not used after migrating from 8.1.7.4 to 10.2.0.2

If you have application running on Oracle 8.1.7.4 and you are massively using CONTEXT indexes, you better analyse the queries where context indexes are involved, before you decide to migrate to 10.2.0.x.
This is because execution paths might be way different in 10.2. (more...)

On the road again

It’s been a long time since my last post on this blog.
Ok, one of the reasons for this “absenteeism” was my new job.
Honestly, I didn’t have too much time to write anything except reports, research papers, proof of concepts, etc.
Although I commute more than I used to, (more...)