XML DB - Sample Corner
The XML DB section contains a series of samples describing how to use the XML DB features of the Oracle9i in real life applications. It also shows the usage of different XML DB packages and utilities that come with the Oracle XML DB and how they make applications and Web sites XML enabled. Please visit our XML sample code section for more XML samples. This page contains the following samples:

Content Management System Application [12-May-2003]
Redhat Linux Certified
With the help of a very simple XML based content management application scenario, this sample demonstrates various XMLDB capabilities and XMLDB APIs to achieve these capabilities. The sample application illustrates following XMLDB capabilities and associated APIs : how to store XML content in Oracle XMLDB Repository, version control XML content, Transform XML content, Search XML Content using Oracle Text, secure content using Access Control Lists, Exchange XML messages using Advanced Queuing and much more.

XML Dynamic News Application [12-May-2003]
Redhat Linux Certified
XML Dynamic News is a complete J2EE 1.3 based application to demonstrate the power of Java and Oracle XML DB features in a real life scenario. The application implements an online News Portal where news feeds are stored and managed persistently in Oracle XML DB. Apart from Oracle XML DB features, the application also demonstrates the use of Model View Controller architecture and various J2EE design patterns.

SAX Loader Application [14-Mar-2003]
Redhat Linux Certified
SAX Loader Application demonstrates an efficient way of breaking large files containing multiple XML documents outside the database and then inserting them as a set of separate documents. SAX Loader application has been provided as both standalone application and as a web based application.
Download (ZIP, 158KB)
Readme
View Source

Simple Bulk Loader Application [14-Mar-2003]
Redhat Linux Certified
Simple Bulk Loader Application demonstrates loading of a directory of XML files into Oracle XML DB using JDBC. This application provides the solution by using a single temporary CLOB object to load the content of multiple XML documents.
Download (JAR, 38KB)
Readme
View Source

Oracle XML DB Utilities Package [14-Mar-2003]
Redhat Linux Certified
The purpose of this package is to highlight the helper subprograms provided with XDB_Utilities package. These subprograms operate on Bfiles, CLOBs, DOM and Oracle XML DB Resource APIs. With the help of this package you should be able to do some basic XML DB Foldering operations, read and load XML files into database and do basic DOM operations through PL/SQL.
Download (ZIP, 16.8KB)
Overview

Card Payment Gateway Application [16-Dec-2002]
Do you want to store all your data in XML format but still want to use SQL to access it ? Yes, you can do that very easily now. Learn how Oracle XML DB features allow you to achieve the same. This sample shows how a credit card company stores its account and transaction data in the database but at the same time maintains XML fidelity. This sample also demonstrates many of the new features of Oracle XML DB.

Oracle9i R2 XML DB Demonstration [19-Sep-2002]
Test Oracle9i R2 XML DB from end-to-end. Try out the latest XML indexing, querying, transformation and updating capabilities as well as accessing XML from multiple protocols including WebDAV, HTTP and FTP. Read the setup documentation and download the sample code.

Oracle9iR2 XQuery Prototype [22-Mar-2002]
Try a prototype of the W3C XQuery language using Oracle9i Release 2.