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

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

Is a rollback possible to any savepoint?

0 Answers  

---

What is a cluster?

2 Answers  

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

How to create a new view in oracle?

0 Answers  

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---

How to convert characters to times in oracle?

0 Answers  

---

What is connection pool in oracle?

0 Answers  

---

How do we represent comments in oracle?

0 Answers  

---

What is the difference between sharding and replication?

0 Answers  

---

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

---

How to invoke the original export import utilities?

0 Answers  

---