Empty string behaviour...

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.

re: Empty string behaviour...

On Thu, 20 Oct 2005 21:17:59 +0200, krofak interested us by writing:

Seems to work (something+'' = something) in 9.0.1.3.1

It would be somewhat useful for you to tell us the version and patchset
you are on, as well as the OS info.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

re: Empty string behaviour...

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

re: Empty string behaviour...

"HansF" <News.Hans@telus.netwrote in message
news:pan.2005.10.20.20.14.53.703819@telus.net...Version: 9.2.0.7. I am not sure about OS, AIX something