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 -> Re: Easy SQL problem

Re: Easy SQL problem

From: Andy Hassall <andy_at_andyh.org>
Date: Sun, 11 Aug 2002 23:29:26 +0100
Message-ID: <q0pdlus0r1b294l66ecisk41dk4a4i2bvn@4ax.com>


On Sun, 11 Aug 2002 15:10:18 +0100, Daniel Morgan <damorgan_at_exesolutions.com> wrote:

>What makes you think that '' is NULL?

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#4008 http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements5a.htm#59112

 "Oracle currently treats a character value with a length of zero as null."

 I'm probably just getting the wrong end of the stick from some of the posts in this thread, but as far as I'm aware Oracle still doesn't differentiate '' from NULL, which is why column = '' can never match (as column = '' is actually column = NULL, and that is always 'unknown').

-- 
Andy Hassall (andy@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyhsoftware.co.uk/space | disk usage analysis tool
Received on Sun Aug 11 2002 - 17:29:26 CDT

Original text of this message

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