In Chapter 7, we discussed the mapping of XML to SQL and SQL to XML. XML SQL Utility is a Java API. However, SQL to XML mapping may also be done with XSQL using the JDBC driver without any Java code. The Oracle XSQL Pages Publishing Framework, which is included in Oracle JDeveloper 10g, supports the processing of SQL queries to generate XML. XSQL may also be used to run SQL DML (Data Manipulation Language) statements other than SQL
SELECT such as
INSERT, UPDATE, and
DELETE. An XSQL page consists of the XSQL tags in the
urn:oracle-xsql namespace. An XSQL page request is sent to the XSQL Servlet, which invokes the XSQL Page Processor.
The XSQL Pages Publishing Framework integrates XML, SQL, and XSLT. The XSQL Page Processor processes ...