Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what sql will be for oracle for FOR XML AUTO, XMLSCHEMA, ELEMENTS XSINIL

722037Sep 20 2011 — edited Sep 20 2011
Hi all,

I have developed an application which supports both database sql server and oracle. I am using sql

select * from test FOR XML AUTO, XMLSCHEMA, ELEMENTS XSINIL, ROOT('test')

to fetch records in xml format from SQL Server.

I want to know what sql will be for oracle to get same result set in xml format.

Thanks in advance.
Edisphere software
Vijay singh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2011
Added on Sep 20 2011
5 comments
692 views