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
- 12153 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / j.n.tripathi
Hi
Sorry To ALL.....
For Above Answer
Writing Mistake there.....
You Can Replace the null without using nvl
function.
using replace key world
like this
Select Replace(values,'null')
from demo
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 | 3 No |
Post New Answer View All Answers
What is function and procedure?
What is sql performance tuning?
How to assign sql query results to pl sql variables?
what are date and time intervals? : Sql dba
What is an escape character in sql?
Why select is used in sql?
What is clause?
What is procedure and function?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is the difference between inner join and left join?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is a unique key and primary key and foreign key?
what is the difference between where clause and having clause? : Sql dba
List out the acid properties and explain?
How is a PL/SQL code compiled?
