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

What are the type of Synonyms?

1 Answers  

---

How to rebuild an index in oracle?

0 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

How to drop a tablespace?

0 Answers  

---

How to work with data objects interactively?

0 Answers  

---

---

How can I see all tables in oracle?

0 Answers  

---

How to start an oracle instance?

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

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

2 Answers  

---

Find all employees in Dept “Marketing”.

2 Answers  

---

How to sort output in descending order in oracle?

0 Answers  

---

What is Java Pool in Oracle?

0 Answers   MCN Solutions,

---