Re: Differentiate Between Zero-Length String and NULLColumn Values

On 1/30/2007 3:17 PM, Jamie A Lawrence wrote:
> Just a datapoint:
>
> SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jan 30 15:15:49 2007
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options

It is well known that Oracle's handling of zero length strings violates
all ANSI SQL Standards, so what exactly is your point?

Jan

>
> SQL> select * from dual where '' IS NULL;
>
> D
> -
> X
>
> SQL> select * from dual where '' = NULL;
>
> no rows selected
>
>
> -j
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #