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>

How to use regular expression in pattern match conditions in oracle?

1030

---

What are the database administrators utilities available?

1018

---

Explain about integrity constraint?

1113

---

What is the usage of merge statement?

1140

---

What is an oracle and why it is used?

1138

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2054

---

Define oracle database

1035

---

What is the order of defining local variables and sub procedures/functions?

1050

---

Whats the benefit of dbms_stats over analyze?

1991

---

How to execute a stored procedure in oracle?

1075

---

What is execute immediate in oracle?

1009

---

What are the different windows events activated at runtime ?

2893

---

How to retrieve the count of updated rows?

1119

---

How to commit the current transaction in oracle?

1104

---

Explain a synonym?

1019

---