Re: SQL Generation

[Jurgen <jurgen.moortgat@oracle.com>]

phil,

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).

cheers,
Jurgen.

Phil Ruelle wrote:
> 
> All,
> 
> Does anyone know of an XML based technology similar to
> Microsoft's RecordSets or Sybase's DataWindows?
> By that I mean something that creates an XML document by
> executing an SQL SELECT statement, allow that document to be
> updated and then generate a suitable SQL UPDATE statement
> using the primary key and only the rows/columns that have changed.
> 
> TIA,
> 
> Phil Ruelle
> 
> ------------------------------------------------------------------
> The xml-dev list is sponsored by XML.org, an initiative of OASIS
> <http://www.oasis-open.org>
> 
> The list archives are at http://lists.xml.org/archives/xml-dev/
> 
> To unsubscribe from this elist send a message with the single word
> "unsubscribe" in the body to: xml-dev-request@lists.xml.org