[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: SQL Generation

• From: Jurgen <jurgen.moortgat@o...>
• To: Phil Ruelle <philr@i...>
• Date: Fri, 30 Mar 2001 14:18:39 +0200

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@l...

• Follow-Ups:
  • Re: SQL Generation
    • From: Steve Muench <Steve.Muench@o...>
  • RE: SQL Generation
    • From: Danny Ayers <danny@p...>

• References:
  • SQL Generation
    • From: Phil Ruelle <philr@i...>

• Prev by Date: RE: attribute order (RE: Syntax Sugar and XML information models)
• Next by Date: Re: attribute order (RE: Syntax Sugar and XML information models)
• Previous by thread: SQL Generation
• Next by thread: Re: SQL Generation
• Index(es):
  • Date
  • Thread