Sunday 12 August 2012

Retrive XML data Using SQL Query

how to retrive xml data for using sql query?

 
SELECT XMLELEMENT
       ("Emp", XMLELEMENT("name", e.fname ||' '|| e.lname),
               XMLELEMENT ( "hiredate", e.hire)) 
AS "RESULT" 
FROM employees e 
WHERE employee_id > 200 ;


This query produces the following typical XML result:

RESULT
-----------------
<Emp> 
  <name>John Smith</name>
  <hiredate>2000-05-24</hiredate>    
</Emp>
<Emp> 
  <name>Mary Martin</name>
  <hiredate>1996-02-01</hiredate>
</Emp>

No comments:

Post a Comment