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;