Oracle

ORDER BY “I am Desperate” DESCENDING

When an SQL result-set needs to be returned in some sort of order, it is not unreasonable to expect that the information to ...Read more

Finding Nemo Onetangi

Being a freelance contractor is often stressful - parachuted into a budget constrained project with tight timeframes and where you know next to ...Read more

Database Table Partitioning – Why?

There are not two common reasons why RDBMS DBA's partition database tables, but five. The two rote answer reasons usually cited for implementing ...Read more

There are times when I think Oracle is not for the experienced hand and that I have lost my touch

Why do I keep falling into the same man traps? Why can I not learn? Why do I put myself through the same debugging exercise ...Read more

Multibit Variable Width Encoded Datatypes – Questions To Myself

As some errors made by programmers are so blindingly obvious, you do not need to check whether the code would even, for example, compile! ...Read more

8, 9, 10, 11, 12, 17 – Of course!

I am likely to be proved wrong. Last year I blogged that the next major version of Oracle might be version 13. It is not an unreasonable ...Read more

Yet another gripe from a Software Developer: I really do wish people wouldn’t “Help Me Out”

Kevin Bacon is one cool dude. From his performances in The River Wild and Footloose, to the unforgettable Hollow Man, he constantly exudes ...Read more

Oracle Recursive With With Currywürste

At the age of 53 I have discovered the currywurst, a most delicious fast food found all over Germany. This food needs to be commercially ...Read more

When you have to resort to statistics, you know it’s time to redesign the software, or throw it away!

Yesterday the system was running fun. Today it is slow. What changed? How many times has this damn question been asked? The answer is ...Read more

Oracle Execution Plan: Stability or Lability?

From statistics derived from data distribution and hardware performance measurements, and the SQL to be executed, the Oracle Cost Based Optimiser (CBO) is the ...Read more