Answer / 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>

Answer / ksonga

SET VERIFY OFF
SET ECHO OFF
SET PAGES 0
SET LONG 100000
SET lONGCHUNKSIZE 10000
SET LINESIZE 200
select dbms_xmlgen.getxml('select * from emp') from dual

Answer / dfd

select * from emp hahahaha

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....

0 Answers  

---

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

Can sub procedure/function be called recursively?

0 Answers  

---

What types of joins are used in writing subqueries?

0 Answers  

---

What are the attributes of cursor?

0 Answers  

---

How to write a query with an inner join in oracle?

0 Answers  

---

Why we choose emp number as primarykey?

4 Answers  

---

How to define a variable of a specific record type?

0 Answers  

---

master table and child table performances and comparisons in Oracle ?

0 Answers  

---

Write a syntax for update query in oracle?

0 Answers  

---

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

How to define a procedure inside another procedure?

0 Answers  

---