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 create a new table in your schema?

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 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 logical backup in oracle?

0 Answers  

---

What is partitioned table in Oracle?

0 Answers   MCN Solutions,

---

---

How to load a large xml file?

0 Answers  

---

How to get execution path reports on query statements?

0 Answers  

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers   Oracle,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

hai, when to use char and varchar2....?

2 Answers  

---

What is the diff between Oracle and SQL Server

1 Answers  

---