Answer Posted / 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

How do you store pictures in a database?

952

---

List out the types of joins.

1083

---

How to drop an existing table in oracle?

1015

---

What is a user role in oracle?

1067

---

What are the uses of a database trigger?

931

---

How do I limit the number of oracle database connections generated by weblogic server?

1008

---

What are the differences between interval year to month and interval day to second?

966

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2191

---

Can I create users through internet explorer in oracle 10g?

1020

---

What is a oracle database?

996

---

What is the recommended interval at which to run statspack snapshots, and why?

2861

---

How to initialize variables with default values?

1162

---

Can we write insert statement in function in oracle?

1027

---

What are the set operators union, union all, minus & intersect meant to do?

939

---

master table and child table performances and comparisons in Oracle ?

2071

---