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>

What is query image?

985

---

Explain mutating triggers.

1034

---

What are the different types of partitions in oracle?

979

---

How to run the anonymous block again?

1132

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944

---

Explain the use of compress option in exp command.

1021

---

What is a synonym? What are its various types?

1110

---

What is set operator oracle?

983

---

How to define and use table alias names in oracle?

944

---

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

2187

---

What is merge statement used for?

1025

---

Explain an index segment?

1124

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5329

---

What is the difference between I and G in Oracle?

1099

---

What is the difference between alert log file and tarce file ?

2172

---