XML and Oracle.

How many of you wanted to get xml output from oracle quickly.. well here is a smiple way

set

pages 0;
SET LONG 100000;
select xmlgen.getxml(‘select * from scott.emp’/*your query should be here*/) from dual;

To get the schema also you can pass the parameter to the getXMl file like this

 select

xmlgen.getxml(‘select * from scott.emp’/*your query should be here*/,2) from dual;

But to get the cheese you should refer to this ..

Quite a good competition to the claim of XML support in MS SQL server.

http://www.cs.utah.edu/classes/cs5530/oracle/doc/B10501_01/appdev.920/a96620/xdb12gen.htm#1656

Regards
Sajay