Converting data from the table to XML format
select dbms_xmlgen.getxml('select employee_id, first_name, last_name, phone_number from employees where rownum < 6') xml from dual
SELECT xmlelement("Name",first_name), xmlelement("ID",id), 2 xmlelement("City", city) 3 FROM employee
Output
XMLELEMENT("NAME",FIRST_NAME) XMLELEMENT("ID",ID) XMLELEMENT("CITY",CITY) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ <Name>SEKHAR/Name> <ID>01</ID> <City>chennai</City> <Name>chandra</Name> <ID>02</ID> <City>Delhi</City> <Name>Suman</Name> <ID>03</ID> <City>Hyderabad</City> <Name>Madhu</Name> <ID>04</ID> <City>Kolkota</City> <Name>Sreedhar</Name> <ID>05</ID> <City>Mumbai</City> <Name>Anuradha</Name> <ID>06</ID> <City>Noida</City>