Bar Solutions WebLog

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.

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.

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.