-
Suppressing repeating values in SQL
Sometimes you my find a need to suppress repeating values in SQL. One case is when your reporting tool does not have such a feature or you just cannot find it fast enough. That happened to me with a report that was to be converted to APEX from Oracle Reports the other week. I could…
-
SQL Access to the alert-log in 11g and an oddity
Quite a while ago I wrote about how to setup the alert log as an external table. Since then 11g has been introduced and is now widely used. It of course changes the location and makes the alert log an xml file. While it is possible to select from it using xml functions like Laurent…
-
Oracle VirtualBox and Developer Days Appliance
At the start of the Christmas break I decided to get started with Oracle VirtualBox 4.0. To get up and going faster with an 11g database I opted to download the pre-made image (called appliance by Oracle) that they use during Developer Days. It has a lot of things pre installed and ready to go. Oracle Enterprise Linux 5…