Hi You Can Replace the null without using nvl function. using replac

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 / jayendra

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

Answer Posted / jayendra

Hi
You Can Replace the null without using nvl
function.
using replace key world
like this
Select Replace(values,'null')
from demo where values!=NULL;
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

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the two characteristics of a primary key?

976

What are the different parts of a package?

1115

Can a procedure in a package be overloaded?

1043

what is log shipping? : Sql dba

1116

Is drop table faster than truncate?

990

What do you understand by case manipulation functions?

1034

What has stored procedures in sql?

1066

What is difference between mysql and postgresql?

1152

what are all the common sql function? : Sql dba

1057

What is the usage of when clause in trigger?

1057

Define SQL and state the differences between SQL and other conventional programming Languages?

1211

Is pl sql useful?

993

Can procedure in package be overloaded?

1085

Which is faster subquery or join?

1217

Which certification is best for sql?

986