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

Home -> Community -> Usenet -> c.d.o.misc -> confused on "where x=null"...

confused on "where x=null"...

From: Mark Harrison <mh_at_pixar.com>
Date: Fri, 02 Mar 2007 23:49:11 GMT
Message-ID: <XJ2Gh.870$8i6.409@newssvr29.news.prodigy.net>


Of course, the proper form is "where x is null", but "where x=null" does not produce a diagnostic.

It also does not match any rows where x is null. Likewise, "where x=''" will not match any string column.

Can somebody explain to me what "x=null" means to Oracle? Is there ever a case where it will produce a meaningful answer?

Thanks!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Fri Mar 02 2007 - 17:49:11 CST

Original text of this message

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