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>

Please explain oracle left join with an example?

960

---

What are the ansi data types supported in oracle?

898

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

---

What is pragma autonomous transaction in oracle?

993

---

What is index-organized table in Oracle?

1021

---

What is a package in oracle?

1028

---

What is MTTR advisor in Oracle?

1035

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2068

---

How to rename an index?

997

---

How can you use check constraints for self referential integrity?

920

---

What is the quickest way to fetch the data from a table?

1001

---

What are the differences between date and timestamp in oracle?

974

---

Difference between inner join vs where ?

979

---

What are the attributes of the cursor?

937

---

How to generate query output in html format?

1036

---