i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

what are the different type of sql's statements ? : Sql dba

0 Answers  

---

How is data stored on a disk?

0 Answers  

---

---

what is a table in a database ? : Sql dba

0 Answers  

---

What are the advantages of the packages

6 Answers   Oracle,

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

Explain the update statement in sql

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

What is the difference between having and a where in sql?

0 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---