On February 21st I did a presentation on CodeGen at AMIS. Just a short presentation on what is possible using this great tool. I have created a couple of questions for the hands-on part of the session.
Read moreBlogging block…
I seem to be suffering from a blogging block (like a writers block, but for a blogger). Maybe it’s my new job at AMIS or the new application at the KPN I am working on. It’s a lot of figuring out what is going on. Reading through other peoples code and try to understand their […]
Read moreWITH Clause
During my work for AMIS I came across a (to me at least) new feature of the SQL engine. Instead of building an inline view in the from clause of a statement you can build this ‘inline view’ before the SQL statement and use the results in the from clause. The syntax is pretty straightforward: […]
Read moreI got tagged!
Jornica tagged me. Thanks for the invitation. Here are a couple of things you may, or may not, know about me. My nickname was given to me about 13 years ago, by a friend. Patch is shorter than Patrick. I am married to Dana. We have 3 kids, Quinty (9), Kayleigh (7) and Mitchell (4). […]
Read moreOracle 11G – Compound Trigger
In Oracle 11G it is now possible to create a compound trigger. One piece of trigger code that holds all the code for the different triggers you would want. Why do we want to have this? Consider a solution for a mutating table problem. Normally you would use about at least three different triggers and […]
Read moreSeasons greetings…
I know December is quite a busy month for everybody, especially for me, with the birthday of my eldest daughter (December 18th), X-mas and my own birthday (December 29th). That’s why things have been quite slow on my blog ;-). But hopefully you will be having a nice end of year and I wish you […]
Read moreOracle 11G – Virtual Columns (Dates)
A couple of days ago there was a question (in Dutch) on the utPLSQL forum about filling up a table with a lot of dates and some info about those dates, like the weeknumber, the dayname etc. I created code using persistent columns at first, so the code would run on a pre-11G installation, but I was […]
Read moreOracle 11G – Virtual Columns
As written before, I am currently trying out some things on Oracle 11G after a presentation by Lucas and Alex of Amis. One of the new features they talked about was the virtual columns option in Oracle. This a column based on an expression that doesn’t really exist in the database.
Read moreSpeed or Readability…
I have been thinking about an issue of speed versus readability lately. Which one prevails over the other. I have a case statement and a loop which positions can be interchanged to come to the same result.
Read moreOracle 11G – Follows in Trigger
I’ve seen a presentation on the 11G new features from Alex and Lucas at Amis. One of the questions posed there was when you are using the new follows option in triggers, what would happen if you have two triggers following the same one. A bit like the way it”s done right now.
Read more