how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is a trigger word?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

What is the trigger in sql?

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

How to execute a stored procedure?

0 Answers  

---

Why we use join in sql?

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---