Total Pageviews

December 14, 2017

12/14/2017 10:02:00 PM
Oracle XML Data type


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>
 
Related Posts Plugin for WordPress, Blogger...