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

Home -> Community -> Usenet -> c.d.o.server -> where clause on null string

where clause on null string

From: Zorglub <no_at_mail>
Date: 13 Nov 2001 12:26:15 GMT
Message-ID: <Xns915888CA14D5FzorglubID1923@213.228.0.32> 





Hello,



why a WHERE myVarCharCol='data' OR myVarCharCol='' returns 0 records ?
I know that there are record with the myVarCharCol containing 'data' and 
some others that contains nothing (they appears empty in DBA studio table 
content browser).



Thanks
Received on Tue Nov 13 2001 - 06:26:15 CST












Original text of this message













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