Category: SQL, XML/SQL, XPath, XQuery
March 25

Creating an alert log via XML/SQL

I don’t know what it is today, but reading Tanel’s post about “Oracle 11g: Reading alert log via SQL“, I just wanted to see if I could manage to do it backwards.

In principle you don’t have to use the statements below, because I noticed that the DBMS_SYSTEM.KSDWRT will do it for you automatically.

The content of my Oracle 11g log.xml file is as follows

 
 Starting ORACLE instance (normal)
 


 LICENSE_MAX_SESSION = 0
 


 LICENSE_SESSIONS_WARNING = 0

So based on Tanel’s blog, could I do the same, but now with XMLDB functions (based on database version 11.1.0.7.0)…

Here it goes.

Read the postCreating an alert log via XML/SQL
March 24

When is an XQuery Statement too Long?

I just saw Daniel Fink’s – OptimalDBA – blog post: When is a sql statement too long? When the following OTN XMLDB Forum post popped up in my mind… “xquery” versus “select xmlquery” and passing clauses. It tells the story about using bind variables and its performance issues, some alternative ways of dealing with things, charactersets and the ORA-19102 error (“XQuery string literal expected”), ORA-19114 (“Error during parsing the XQuery expression: string”) or ORA-01704 (“String literal too long”).

So when is a XQuery string too long…?

…

Read the postWhen is an XQuery Statement too Long?
December 24

Always Handy? – HELP! – SQL*Plus Reserved Words

One of the most (idiotic posts /) read posts on this website is “Oracle 11g – SQL*Plus Command Line Options“. Somehow syntax examples do well via Google…

(So before the end of the year I want to try if I can beat that one…).

The other post was created after a having made a typo on the command line.

Today, since a long long time, after seeing that help for sqlplus is installed during a default database install, I thought, lets check it once again..

The lists for reserved words for SQL and PL/SQL (in this case Oracle 11g) can be handy. The following is a simple method to check, that is if help is installed.

😎

Read the postAlways Handy? – HELP! – SQL*Plus Reserved Words