Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15239 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 are all the common sql functions?
How many types of cursors are available in pl/sql?
Why are aggregate functions called so?
how to return query output in html format? : Sql dba
What is update query?
What is the difference between a procedure and a function?
Is left join inner or outer by default?
What is scope of pl sql developer in future?
How to pronounce postgresql?
What are the various levels of constraints?
how to drop an existing table in mysql? : Sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
What is trigger and how to use it in sql?
What is view? Can we update view
What is data control language (dcl)?
