dbms_xmlgen

create table something (
  id    number primary key,
  col_1 varchar2(10),
  col_2 date
);

alter session set nls_date_format = 'dd-mon-yyyy';

insert into something values (1,'one',   '23-may-1905');
insert into something values (2,'two',   '16-feb-1875');
insert into something values (3,'three', '29-sep-1891');

set long 10000
set pagesize 1000

select dbms_xmlgen.getxml('select * from something') from dual;

DBMS_XMLGEN.GETXML('SELECT*FROMSOMETHING')
--------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <ID>1</ID>
  <COL_1>one</COL_1>
  <COL_2>23-may-1905</COL_2>
 </ROW>
 <ROW>
  <ID>2</ID>
  <COL_1>two</COL_1>
  <COL_2>16-feb-1875</COL_2>
 </ROW>
 <ROW>
  <ID>3</ID>
  <COL_1>three</COL_1>
  <COL_2>29-sep-1891</COL_2>
 </ROW>
</ROWSET>