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

pls explain connect by prior with example and its real time use

3 Answers  

---

What is a recycle bin in oracle?

1 Answers  

---

Who developed oracle & when?

0 Answers  

---

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

What is an Oracle Instance?

0 Answers  

---

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

What is object data modeling?

0 Answers  

---

How to execute a stored program unit?

0 Answers  

---

What is an Integrity Constrains ?

3 Answers  

---

How to store only time; not date and time?

0 Answers  

---