Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> is null / = null query

is null / = null query

From: <GKor_at_rdw.nl>
Date: Thu, 9 Nov 2000 15:12:08 +0100
Message-Id: <10675.121567@fatcity.com> 





Hi everyone



I have launched the following query in SQL*PLUS



SQL> L



  1* SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO = NULL;

SQL> /



         0



1 row selected.



SQL> SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO IS NULL;

       301



1 row selected.



SQL>


i did'nt expect to get answer on the first query



anyone with an explanation or is this a undocumented feature ?



thanks



gkor_at_rdw.nl
Received on Thu Nov 09 2000 - 08:12:08 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US