Hi Sorry To ALL..... For Above Answer Writing Mistake there.....

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);

Question Posted / j.n.tripathi

11 Answers
15617 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / j.n.tripathi

Hi
Sorry To ALL.....
For Above Answer
Writing Mistake there.....

You Can Replace the null without using nvl
function.
using replace key world
like this
Select Replace(values,'null')
from demo
it will display the result like this
1 2 3
3 4
1 5

Thanks
J.N.Tripathi
9868703898

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql procedural language?

1013

How do I count duplicates in sql?

1176

What are different types of functions in sql?

1054

What is the difference between joins?

1094

what is the difference between undefined value and null value? : Sql dba

1145

what is single byte over head in oracle..?

2456

Does google use sql?

1006

How can a function retun more than one value in oracle with proper example?

1124

What is consistency?

1187

What is pl sql collection?

1017

What is range partitioning?

1014

List the various privileges that a user can grant to another user?

1091

how to enter binary numbers in sql statements? : Sql dba

1011

What is rtm stands for?

1173

Can a table have no primary key?

1110