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
15230 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 anonymous block in sql?

1118

Is ms sql traffic encrypted?

920

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

how to show all tables with 'mysql'? : Sql dba

1111

What are triggers in sql?

1014

What is the difference between having clause and where clause?

1057

What is oracle sql developer?

1041

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1009

What is sharding in sql?

969

What is pl sql package?

1029

Which query operators in sql is used for pattern matching?

957

how to use in conditions? : Sql dba

1009

What does trigger mean in slang?

1048

Write a sql query to get the third highest salary of an employee from employee_table?

1067

How to add a column ‘salary’ to a table employee_details?

1008