Re: Violation of NOT NULL

>
>
>>With that said if '' does != NULL then what does? Just NULL? In my book
>>NULL means undefined and IMHO you can't get more undefined than ''!
>>
To me, '' is very defined.  You're explicitly telling something to be 
set to the empty string.  It has a definite value - "empty string". 
 NULL implies that you have no information whatsoever to determine what 
the value is.

That's just me. I was always bothered that Oracle did consider empty 
strings to be NULLs.  =)

-Fran