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 can I introduce multiple conditions in like operator?

0 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

Does oracle charge for java?

0 Answers  

---

What are the execution control statements in oracle?

0 Answers  

---

Can we create trigger on view in oracle?

1 Answers  

---

What are the general rules on data consistency?

0 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

How to establish administrator authentication to the server?

0 Answers  

---

Explain how are indexes update?

0 Answers  

---

Difference between hot backup vs. Cold backup?

0 Answers  

---

What is trigger associated with the timer ?

1 Answers   Oracle,

---

How to do paging with oracle?

0 Answers  

---