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? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
