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
- 15618 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
What are the types pl/sql code blocks?
Why we use stored procedure instead of query?
How are functions and procedures called in PL/SQL?
What is record variable?
What is sql exception?
Can a varchar be a primary key?
What is data control language?
How to read xml file in oracle pl sql?
what is transaction? : Sql dba
What is the use of non clustered index?
Does sql require a server?
What is having clause in sql?
What is the difference between null value, zero, and blank space?
What is sql keyword?
What is sql*loader and what is it used for? : aql loader
