how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

Explain what are the different type of segments?

0 Answers  

---

Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

How to work with data objects interactively?

0 Answers  

---

---

What are the Limitations of a CHECK Constraint ?

5 Answers  

---

How to filter out duplications in the returning rows using oracle?

0 Answers  

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

what is the difference between primary key & foreign key?

57 Answers   CTS, Infosys, La Multi, Sparsh, Wipro,

---

How to store pictures on to the database?

0 Answers  

---

What are the different pseudo commands? Explain in general?

0 Answers  

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---