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>

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.

1730

---

How to assign query results to variables?

1027

---

What is oracle thin client?

990

---

How to get execution path reports on query statements?

949

---

Please explain joins in oracle?

1028

---

Explain the use of inctype option in exp command.

1000

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2871

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1040

---

Which environment variables are absolutely critical in order to run the OUI?

2091

---

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

2149

---

How to update values in a table in oracle?

983

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2242

---

How to do paging with oracle?

967

---

What are the differences between interval year to month and interval day to second?

991

---

What is connection pool in oracle?

949

---