3 ms·
> treats empty strings and NULLs as the same thing Wow, that's ridiculous. They are very clearly two different things. For example "this has no value" and "we
by RHSeeger 8y ago
> treats empty strings and NULLs as the same thing
Wow, that's ridiculous. They are very clearly two different things. For example "this has no value" and "we don't know the value of this".
- paulddraper 8y agoMore like "this value is empty text" and "this has no value/is unknown". I agree though. Makes as much sense as treating 0 and NULL as the same.
- kijin 8y agoWhat does ANSI SQL say about the matter? If Oracle's behavior is non-standard, it makes sense for the aforementioned author to ignore it.
- irrational 8y agoMy understanding is that Oracle's behavior existed prior to the standard. That is, Oracle came first, then the standard was written years later. Oracle hasn't changed to match the standard because of issues with backwards compliance.