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

IS it possible to built the oracle database without setting the kernal parameters?

0 Answers   EDS,

---

Describe the types of sub query?

0 Answers  

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

How to define a procedure inside another procedure?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

How to insert a new row into a table in oracle?

0 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What are the uses of Rollback Segment ?

2 Answers  

---

What happens if you use a wrong connect identifier?

0 Answers  

---

How to import one table back from a dump file?

0 Answers  

---

how to get the second max val for every group in a table

6 Answers   Verizon,

---

What is oracle datasource?

0 Answers  

---