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);
- 11 Answers
- 12829 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
How to revise and re-run the last sql command?
What is parallel hint?
how to present a past time in hours, minutes and seconds? : Sql dba
What is difference between hql and native sql?
What is the purpose of cursors in pl/sql?
What is function and procedure?
how to include comments in sql statements? : Sql dba
What are the different types of sql commands?
How do I run a script in sql developer?
What is the sql query to display the current date?
what is bcp? When does it used? : Sql dba
What is the purpose of my sql?
What is difference between inner join and self join?
What is varchar example?
What is the non-clustered index in sql?
