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!

Oracle equivalent of "for xml auto, elements"

615607Jan 2 2008 — edited Mar 4 2008

Apologies if this is a bit of a "newbie" question.

I have a .NET application that makes extensive use of the SQL Server syntax "for xml auto, elements" to retrieve data as an XML stream and then merge this with XSL to produce reports.

I would like to support both Oracle and SQL Server. Is there a simple way to do this without writing an Oracle specific interface and rewriting all my SQL?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2008

Added on Jan 2 2008

4 comments

1,072 views