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
14799 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

how to convert dates to character strings? : Sql dba

1069

What is the difference between partitioning and sharding?

946

what is heap table? : Sql dba

1045

How to use transactions efficiently : transact sql

989

What is dba in sql? : SQL DBA

994

How many subqueries can be nested in a statement?

931

How many clustered indexes can be created on a table?

1022

Which is faster subquery or join?

1142

Explain correlated query work?

989

Does truncate need commit?

890

what is a join? : Sql dba

960

what are all the different types of indexes? : Sql dba

995

Which language is used in sql?

987

Why sql query is slow?

928

What pl/sql package consists of?

1029