11. Display the client number and name and the client number and name of the person who referred that client.

0 Answers   Wipro,

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

0 Answers   EDC,

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

What is a cluster?

2 Answers  

---

What is COST-based approach to optimization ?

5 Answers  

---

How to do a full database export?

0 Answers  

---

How many types of cluster table in Oracle?

0 Answers   MCN Solutions,

---

How to create a new view in oracle?

0 Answers  

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

0 Answers  

---