Re: Oracle NULL vs '' revisited

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 17 Aug 2007 17:08:00 -0700
Message-ID: <1187395682.84079@bubbleator.drizzle.com>

zigzagdna_at_yahoo.com wrote:

> On Aug 17, 5:23 pm, "David Portas"
> <REMOVE_BEFORE_REPLYING_dpor..._at_acm.org> wrote:

>> <zigzag..._at_yahoo.com> wrote in message
>>
>> news:1187385280.227081.226550_at_g4g2000hsf.googlegroups.com...
>>
>>> On Aug 17, 10:49 am, Matthew Harrison <m.harris..._at_craznar.com> wrote:
>>> Any value you put in the field/variable is
>>> not same thing as null.
>> Agreed. Any value is not the same thing as null
>>
>>> In my view, Oracle's approach is the right approach.
>> Huh? But Oracle's approach is that the empty string value IS the same thing
>> as null!
>>
>> --
>> David Portas

> 
> I was not aware of that, but I do not belive same applied to other
> data types such as integer,

Then you would be incorrect: It does.

Though I wouldn't suggest inserting an empty string into a DATE column.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Aug 17 2007 - 19:08:00 CDT