4
Using XML-SQL Utility (XSU)

This chapter contains the following sections:

• Accessing XML-SQL Utility

• Using XML-SQL Utility (XSU)

• Where Can You Run XML-SQL Utility (XSU)?

• XSU Usage Guidelines
  • Mapping Primer

  • Using the XSU Command Line Front End

  • Generating XML from ResultSet Objects

• XML-SQL Utility for Java
  • Paginating Results: skipRows and maxRows

  • Generating XML from ResultSet Objects

  • Raising No Rows Exception

  • Storing XML

  • Insert Processing

  • Update Processing

  • Delete Processing

• Using the XML-SQL Utility for PL/SQL
  • Setting Stylesheets in XSU (PL/SQL)

  • Binding Values in XSU (PL/SQL)

  • Storing XML in the Database Using DBMS_XMLSave

  • XSU Insert Processing in PL/SQL

  • Update Processing

  • Delete Processing

• Advanced Usage Techniques

• Frequently Asked Questions (FAQs): XML-SQL Utility (XSU)