Codedrop™ Weblog

A very useful feature of Oracle is the ‘CONNECT BY’ command. I make use of this whenever I need to generate any SQL output that has any sequential data as a key to the query. For example, a report of the number of logins per day or per hour.
To use connect by [...]

Here’s a quick solution for trying to extract the raw xml string from an Oracle XDB database when working with Grails.
After an initial attempt to hardcode a hibernate query to return the raw sql using .getStringVal() as follows:
SELECT x.id, x.xmlData xmldata.getStringVal(), lines.*
FROM xml_requests x
XMLTable(’declare [...]

Below are the installation note’s I captured in installing Oracle10.2.0.1 on a Fedora 8 workstation. For some reason installations ofOracle on Fedora linux in past never went as smooth as hoped.. I washowever relatively happy with how things turned out on F8 and its niceto see some of the old problems, like hanging during [...]