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
- 12087 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
How do I filter in sql profiler?
Are null values same as that of zero or a blank space?
How can I see all tables in sql?
Define select, insert, create, delete, update, drop keywords
What is sap sql anywhere?
Difference between table function and pipelined function?
How to avoid duplicate records in a query?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How can you select unique records from a table?
What is dbo in sql?
When can we use the where clause and the having clause?
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
where are cookies actually stored on the hard disk? : Sql dba
What is the difference between local variables and global variables?
How do you pronounce sql?
