Archive for November, 2007

Oracle 11G - Virtual Columns

Wednesday, November 21st, 2007

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.

Speed or Readability…

Thursday, November 8th, 2007

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.

Oracle 11G - Follows in Trigger

Saturday, November 3rd, 2007

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.