OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL Generation


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


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