This section describes the installation of the Oracle9i XML.

The application will accept user inputs for Product and Customer details for creating a Product Order XML document. The document created adhers to the given schema ProductOrder.xsd. The application also allows the XML document to be saved into the database.

Learn the fundamentals of major XML industry standards and how to use them with your Oracle database. Discover several ways to transport data to and from your Oracle database. XML is an open standard that allows complicated information to be transferred over the Internet and used by a variety of applications, providing flexibility and increased interoperability essential to Internet business practices.

OTN developers have built sample applications that demonstrate the features of Oracle XML Developer's Kits(XDK) for Java and Oracle9i native XML support. The Employee Information sample application manages employee information in the database. It provides interface for Adding, Updating, Deleting and Viewing of Employee Information stored in the database. All database operations and presentation of data to the user in the application are done through the XSQL pages publishing framework which is available as part of the Oracle XML Developer's Kit(XDK) for Java.

Oracle XML Developer's Kit (XDK) provides components, utilities, and interfaces you can use to take advantage of XML technology in database applications. You can use different parts of the XDK for different projects, depending on application requirements, programming preferences, and development and deployment environments. Oracle has implemented support for XML and the XDK throughout its products and applications.

In Part 1, we introduced you to XML. In Part 2, we described Oracle products that support using XML in database applications. In this document, we describe how to use XML and Oracle XML products to customize presentation of data.

XSQL servlet - as distinct from the XSU described above - is a tool that processes SQL queries and outputs the result set as XML. As a standard java servlet it should work with any java enabled web server. As input it uses an "XSQL" file: an XML file containing embedded SQL queries. XSQL pages are similar to ASPs/JSPs but give XML as output and allow for standard XML processing using XSL.