Re: reading ms sql's "for auto" xml into oracle

> When I do a quick query against SQLServer using the "for xml auto"
> tag, I get rows like this:
> <test val1="one" val2="x" />
> <test val1="two" val2="y" />
> <test val1="three" val2="z" />

I haven't used this in SQL Server, but what you've written above is *not* XML format. What you have above are name/value pairs, and XML is not name/value pairs like this. The example you provided as Oracle's output is XML output.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"