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
14803 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 kind of join is join?

903

What is synonyms?

999

What is vector point function?

1001

what are the differences among rownum, rank and dense_rank? : Sql dba

980

How do I make my sql query run faster?

890

What is full join in sql?

937

What do you mean by “trigger” in sql?

1015

What is the usage of when clause in trigger?

989

Are stored procedures compiled?

870

How do I run a program in pl sql?

950

Which are the different case manipulation functions in sql?

952

What is mdb stand for?

960

What is assignment operator in pl sql?

967

What information is needed to connect sql*plus an oracle server?

977

Is oracle sql free?

926