Re: Empty string behaviour...
Date: Fri, 21 Oct 2005 19:14:52 +0200
> Today, I noticed different empty string behaviour then I am
> used to.
> Before, empty string was treated as null, so statement
> vcResult := 'something' || ''
> would result in vcResult = ''.
> Today, result of this statement was vcResult = 'something'.
> Does anybody know, when (which patchset) did this behaviour
> with treating empty strings as null change?
> I find myself fascinating.
Not in Oracle... An empty string in Oracle is NULL. NULL concatenated to s string is that string (nothing more, nothing less).
I find you less fascinating; you obviously post in the wrong group.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Fri Oct 21 2005 - 19:14:52 CEST