Re: bug or feature, || -operator and NULLs

Mario Weilguni wrote:
>> This has been been discussed before, but Oracle behaves differently,
and
>> IMHO in a more correct way.
>>
>> The following query returns NULL in PG:
>> SELECT NULL || 'fisk';
>>
>> But in Oracle, it returns 'fisk':
>> SELECT NULL || 'fisk' FROM DUAL;
>>
>> The latter seems more logical...
>
> I've worked alot with oracle a few years ago and I agree, the feature
is handy
> and makes sometimes life easier, but it's simply wrong. I heard a
while ago
> that newer oracle versions changed this to sql - standard, is this
true?

Unfortunately not, in Oracle's current version (10.2.0.2.0)
it is still that way.

I think that this Oracle 'feature' is almost as terrible as the
fact that they treat '' as NULL, which is (as has been pointed
out) most likely the reason for treating NULL as '' in ||.

Yours,
Laurenz Albe