how to retrive xml data for using sql query?

Question Posted / srinu

3 Answers
6398 Views
IBM, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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>

Is This Answer Correct ?

13 Yes

0 No

how to retrive xml data for using sql query?..

Answer / ksonga

SET VERIFY OFF
SET ECHO OFF
SET PAGES 0
SET LONG 100000
SET lONGCHUNKSIZE 10000
SET LINESIZE 200
select dbms_xmlgen.getxml('select * from emp') from dual

Is This Answer Correct ?

7 Yes

0 No

how to retrive xml data for using sql query?..

Answer / dfd

select * from emp hahahaha

Is This Answer Correct ?

2 Yes

11 No

Post New Answer