Am Mittwoch, 18. Oktober 2006 13:52 schrieb Andreas Joseph Krogh:
> 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?