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.

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

Quote:

Does anybody know, when (which patchset) did this behaviour
with treating empty strings as null change?

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 ***

krofak wrote:

Quote:

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...

"HansF" <News.Hans@telus.netwrote in message
news:pan.2005.10.20.20.14.53.703819@telus.net...

Quote:

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

Quote:

>Does anybody know, when (which patchset) did this behaviour
>with treating empty strings as null change?

>
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.

Version: 9.2.0.7. I am not sure about OS, AIX something

Empty string behaviour...

re: Empty string behaviour...

re: Empty string behaviour...

re: Empty string behaviour...

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about