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

Hi Can any one tell me what are the API's used in requisition import.

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

What is TNS File

7 Answers   Thermotech,

---

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

---

What is a data segment ?

1 Answers  

---

What is tns service name?

0 Answers  

---

What are the logical operations?

0 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

Explain an exception?

0 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---

What are advantages fo Stored Procedures?

1 Answers  

---