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
- 15267 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 restrict in sql?
What is an inconsistent dependency?
What is the difference between numeric and autonumber?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Which one is better subquery or joins?
What are schema-level triggers?
Which sql most popular?
Explain mutating table error.
How many types of triggers exist in pl/sql?
How is a process of pl/sql compiled?
How would you reference column values before and after you have inserted and deleted triggers?
Is ms sql traffic encrypted?
What are the disadvantages of not performing database normalization?
What is aggregate function in sql?
What found sql?
