XDK

select dbms_xmlgen.getxml('select * from emp') from dual;
above query will give table data as xml.

declare
xml_string varchar2(4000);
flag number(5):=0;
begin
xml_string='';
flag:=dbms_xmlsavexmlgen.insertxml('scott.emp',xml_string);
end;