Re: SQL Generation

[Steve Muench <Steve.Muench@oracle.com>]

| try Oracle's Xml Sql Utility (downloadable from technet), this
| utility allows you to generate an XML document based on a query.
| you can also insert/update a table/view based on the content of an
| XML Document (so you don't need to generate update statements
| yourself).

Some important additional info on the Oracle XML SQL Utility:

  -> Supports any JDBC driver
  -> Fully supports all Oracle object/relational features
  -> API's for String, DOM, SAX2, or stream XML output

It's now part of the integrated "Oracle XDK for Java"
downloadable from http://otn.oracle.com/tech/xml

______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/