Monthly Archives: August 2007

QDA on tables…

When you are implementing the QDA in an existing application, you may want to know what tables have the QDA implemented and what tables don’t have it implemented yet. I have created two SQL statements that retrieve this information from the data dictionary.

Read more

9 years…

It’s been nine years since I married my lovely wife. Congratulations to you on living with me for all this time. I hope this is just the beginning of a long period. We have 3 lovely kids and I hope we can enjoy them and each other a long time to come. Gefeliciteerd, Dana, met het […]

Read more

Tri-state boolean

All data types in the Oracle database implement the null value. Null is a very special value which means ‘Unknown’. That means that the value is really unknown. Null is not equal to null, because both are not known. Therefore you cannot compare them to each other. Even the boolean value has this null value […]

Read more

Oracle errors…

I’m sure everybody ran into an error of some sort when using Oracle. Some errors are really obvious, you are trying to select a column that doesn’t exist, assigning a variable that hasn’t been declared, that kind of errors. But there are also errors that you don’t run into that often, maybe it’s even the […]

Read more

Open cursors…

Today I came across a very strange problem in the code I am working on. The code raised a correct error, when executed the first time, but ran with no problems the second time. After a lot of debugging (even built a log package, hopefully so generic it will one day make it to my […]

Read more