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 to define an anonymous block?

0 Answers  

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,

---

Calculate difference between 2 date / times in oracle sql?

0 Answers  

---

How to delete all rows a table in oracle?

0 Answers  

---

Why do we use bulk collect in oracle?

0 Answers  

---

What is the CAP theorem?

1 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---

Explain the use of grant option in exp command.

0 Answers  

---

How can we Update a table with out using UPDATE command?

1 Answers  

---

How to count groups returned with the group by clause in oracle?

0 Answers  

---