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);
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
Where is all the data on the internet stored?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can we call dml statement in function?
What is a delimiter in sas?
Which is better trigger or stored procedure?
What can I use instead of union in sql?
What is an exception in pl/sql?
What is the life of an sql statement?
Can we perform dml in function?
How do I order columns in sql?
Can we have two clustered index on a table?
What are the types of operators available in sql?
What pl/sql package consists of?
Define SQL and state the differences between SQL and other conventional programming Languages?
what is the difference difference between procedure and packages