DBMS_XMLGEN.GETXMLTYPE

select
   dbms_xmlgen.getXmlType(
      'select * from dual'
   ).extract('//DUMMY/text()') dummy
from
   dual;