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
- 15291 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / chandra shekhar
Dear Lavanya,
You cannot equate the NULL with the operators like = and !=
NULLs can be equated with "IS NULL" or "IS NOT NULL"
(Double quotes " not included)
In u r query if u say IS NOT NULL, then also as per question asked in the very beginning it will not suffice.
As there are multiple columns with multiple NULLs in all the given columns .
Regards
J
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain 3 basic parts of a trigger.
Is it possible to pass parameters to triggers?
how to use case expression? : Sql dba
What is cursor in pl sql with examples?
What is query execution plan in sql?
What are tables and fields in the database?
What is cursor explain with example?
what are the features and advantages of object-oriented programming? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
How is data stored in sql?
What are triggers in sql?
What is thread join () in threading?
Are stored procedures faster than queries?
What are procedures used for?
What is file based approach?
