Re: Empty string behaviour...

krofak wrote:
> 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...