XML

Alert Log, DBA, Oracle, SQL, XML

SQL Access to the alert-log in 11g and an oddity

TweetShareSharePin0 SharesQuite 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 Schneider does here, it is still a bit cumbersome. Tanel Poder (@TanelPoder) found a nicer way by usingĀ X$DBGALERTEXT which does a really nice job […]

AQ, Oracle, XML

Advanced Queuing

TweetShareSharePin0 SharesI have just uploaded an article I wrote almost five years ago to the day. It was my first attempt and I wrote about Oracle AQ which is Oracle version of a messaging product. AQ is included with the database and has a lot of nice features including full support for XML payloads. Another important benefit is that your messages are synchronized with your DML as both are committed in the same transaction. You can find the article here. […]

Challenge, Oracle, SQL, XML

SQL Challenge I – Solution

TweetShareSharePin0 SharesBoth Gary and Philip postd working versions. Gary’s didn’t work for me when I had the same letter more than one time in the string. Philips did work and the need to deal with each letter as if it is unique can of course be questioned. The intent was for a solution that could handle that and as Philip showed adjusting that is as easy as to just add a distinct. My version is based on not using analytical […]

Oracle, SQL, XML

Dynamic in-line queries

TweetShareSharePin0 SharesI don’t know of a better name for this feature. I think this name describes the function well, even if it may sound overly ambitious. This whole post will be based on a post by Laurent Schneider where he uses XML features to do a select count(*) from different tables and return the result in one result table. It is like a auto generated number of selects that are unioned together. You can find Laurent’s post here. It’s a […]