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 moreTri-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 moreOracle 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 moreOpen 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 moreNot much happening…
Lately I’ve been doing lots of production work at the customers site, so there’s not really much that involves new techniques etc. I did however come up with a nice solution to a small problem I faced. Order results by the last character. In normal SQL you can do an Order by to order by […]
Read moreWhat’s new???
Well, for one thing, I got a new laptop from the office. This one is great. It’s get an Intel Centrino Dual Core processor (2GHz) and 3.5 Gb of RAM. Wow, that’s about 3.5 times as much as I used to have ;). Downside of getting a new laptop is having to install all the […]
Read moreBy position or by name…
In Oracle PL/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think. Consider the betwnstr function (posted last time) and these calls (all have the same result): l_varchar := betwnstr(‘hello world’ , 3 , 5 , true); l_varchar := betwnstr(‘hello […]
Read moreAutomatic Syntax Highlighting…
In Windows Live Writer you can add Plugins that do certain things for you. One of those things is to add syntax highlighting to your postings. I found a Code Formatter for Windows Live Writer that does just about all you need, except of course for PL/SQL (and Delphi) code. Doing some more searching on […]
Read moreCodeGen presentation (2)
Yesterday I did the presentation on CodeGen at the Amis Academy. There were about 12 people to see what I was talking about. In about an hour I showed a bit about how CodeGen works, what you can do with it (and what you can’t) and what the QDA is. After the theoretical information, it […]
Read moreCodeGen presentation
Just one more sleep until my presentation on CodeGen at the Amis Academy. Lucas Jellema blogged about this presentation on the Amis Technology Blog. I hope it will be fun and that there will be a good many people to watch it. Hope to see you there.
Read more