how to retrive xml data for using sql query?
Answer Posted / d ashwin
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 |
Post New Answer View All Answers
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to assign query results to variables?
What is oracle thin client?
How to get execution path reports on query statements?
Please explain joins in oracle?
Explain the use of inctype option in exp command.
What is a Garbage Collection? and what is full recursive Garbage collection?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Which environment variables are absolutely critical in order to run the OUI?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to update values in a table in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to do paging with oracle?
What are the differences between interval year to month and interval day to second?
What is connection pool in oracle?