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  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

---

What are triggers in sql?

0 Answers  

---

what is inline view?

15 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is oracle sql developer?

0 Answers  

---

What are the disadvantages of file system?

0 Answers  

---

How to select 10 records from a table?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

State some properties of relational databases?

0 Answers  

---