What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---

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 mutating sql table?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---

What is the difference between mdf and ndf files?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

What are the advantages of pl sql over sql?

0 Answers  

---

How do you update a value in sql?

0 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

What type of database is sql?

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is primary key and unique key?

0 Answers  

---