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
- 15151 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 primary key and foreign key and how they work?
What is the difference between cross join and natural join?
What are the two types of cursors in pl sql?
Does sql*plus also have a pl/sql engine?
Why do we need sharding?
How many joins in sql?
What is an inconsistent dependency?
What are the different types of triggers?
What is an exception in PL/SQL? What are the two types of exceptions?
What is transaction control language (tcl)?
Differentiate between % rowtype and type record.
Which is better varchar or nvarchar?
How can I speed up sql query?
Define commit, rollback and savepoint?
How much ram can sql express use?
