Answer / manoj

Suppose that the tables are having same structure:

insert into T4 ( select <col1>,<col2>, ...<colN> from T1
UNION select <col1>,<col2>, ...<colN> from T2 UNION select
<col1>,<col2>, ...<colN> from T3)

What does `(+)` do in a where clause?

1 Answers  

---

What is the usage of control file in oracle?

0 Answers  

---

What is the implicit cursor in oracle?

0 Answers  

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

What is ADDM Advisor in Oracle?

0 Answers   MCN Solutions,

---

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

---

what is the difference between rollback & commit? can a foreign key has null value?

6 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

Give the Types of modules in a form?

1 Answers  

---

what are different types of locks?

6 Answers  

---