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
- 13418 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 Execute a Package in PL/SQL.?
How many types of keys are there in sql?
How do I quit sql?
What are different types of triggers?
What is a procedure in pl sql?
What are the various restrictions imposed on view in terms of dml?
What is sqlerrm?
What is a join?
tell me about various levels of constraint. : Sql dba
What is a temporal data type?
What is scope of pl sql developer in future?
What is the difference between count 1 and count (*) in a sql query?
how mysql optimizes distinct? : Sql dba
What are the most important characteristics of pl/sql?
What is sql character function?
