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
15615 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 is the difference between rename and alias?

1390

How do I kill a query in postgresql?

1186

what is commit? : Sql dba

1124

Are sql connections encrypted?

1085

Is left join faster than inner join?

1168

How do you drop a trigger?

1036

What are the types of triggers in sql?

1141

How do you get column names only for a table (sql server)?

1213

What is sql architecture?

1102

What is composite data type in pl sql?

1169

Why is nosql good?

1082

How does left join work in sql?

1039

What are the main features of cursor?

1108

How to check if a column is nullable before setting to nullable?

1183

What is partition by in sql?

1126