Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 1 very small question for a fundamental concept.
Hello Oracle gurus!
==>As always it s about null values<==
select TOTO from BABA where TOTO <> 1;
select TOTO from BABA where TOTO <> 1 or TOTO is null;
why first statement does not return null values? Am I obliged to specify the statement "or TOTO is null" ? "1 <> null" condition is true or not?
does that behaviour can be circumvented?
Thks!
Xav Received on Thu Oct 02 2003 - 14:04:39 CDT