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

what is single byte over head in oracle..?

2453

what is a table in a database ? : Sql dba

1087

What are types of exception?

958

How do I filter in sql profiler?

1045

What are the triggers associated with image items?

1082

What is the difference between instead of trigger and after trigger?

1061

What are dml commands?

1069

Is primary key clustered or nonclustered?

1057

what are the types of subquery? : Sql dba

1151

What is difference between cursor and trigger?

1126

What is normalisation and its types?

1040

What is trigger in sql? Explain

1037

What is the starting oracle error number? What is meant by forward declaration in functions?

1039

What is a .db file?

1039

Is the primary key an index?

1073