Arto Viitanen wrote:
> Tony Andrews wrote:
>
>> All correct - for Oracle. But note that the ANSI standard is that the
>> empty string is NOT null, and "where '' = ''" should always be TRUE.
>> This Oracle anomaly is a trap for those used to other DBMSs that honour
>> the ANSI standard on this point.
>>
>
> I used to think this also. But honestly, where do you use value ''?
That doesn't matter; NULL is undefined, '' is defined: it's an empty string.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Mar 20 2006 - 12:05:18 CST
