Pipelined functions are an extremely useful feature of Oracle 9i and above. They allow you to present disperate nontable based data as a standard table whilst streaming the output so that processing can begin immediately. I.e., they let you SELECT from a function much like you would SELECT from a table. Cool huh? Why would […]

Many people seem to have trouble reading XML data within Oracle.

Oracle has a full library of routines built in to allow you to interrogate XML data. Unfortunately, they’re not very well documented.

Just say you have an XML file you want to be able to SELECT from. it looks like this:

HTTP, HTTPS, FTP, WebDAV including WebDAV Version Control Oracle XML DB is not a separate server; it is an integral part of the Oracle database, providing all of the high-availability, scalability, reliability and unbreakable security features needed to run mission-critical applications. You can use Enterprise Manager to manage and administer XML DB applications. The GUI […]

Today’s bottom-line business impact of adopting XML technologies is especially important. For any organisation that shares information with its counterparts as a critical part of its delivelables, the creation of a single source of information from which we can deliver to all current and future media will deliver real, sustainable benefits. Faster time to market […]

Why XML? XML (and its predecessor SGML) was developed as an answer to the desire for a single source format. XML represents any type of information in a media-neutral format. This enables automation, which speeds delivery, permits enhanced functionality, and reduces costs. XML has the additional virtue of being a standard without competition; virtually every […]

Every new technology comes with its own acronyms and subtleties. Below is a glossary of common terminalogy you will encounter working with Oracle XMLDB. ACE (Access Control Entry) An entry in an Access Control List. ACL (Access control list) A method for limiting the use of a specific resource to authorised users. SGML (Standard Generalised […]

The FISH tool was developed for the Scotland and Northern Ireland Forum for Environmental Research to classify fish populations in Rivers throughout the UK. The software was developed in Oracle with the new APEX 3.2 release. Custom HTML / CSS APEX templates were created including custom logon screens and admin sections. JQuery is used to […]

River Invertebrates Classification Tool is a software application that allows the Environment agencies to determine the ecology classification of water bodies throughout the UK. The software makes use of Oracle, XML, Web services, CSS, RSS and custom stastistical functions implemented in Oracle and ported from Insightful S+. Raw river data sets collected by ecologists are […]

Blucel designed and developed an SOA application that interacts with Oracle and Insightful S+ server. The software send raw Oracle data from environmental sampling surveys throughout the UK, the data transport mechanism sends the raw data as XML instances of XSD schema documents. S+ receives the data using a C# web service, converts it to […]