Empty string behaviour...

Question posted by: krofak (Guest) on June 27th, 2008 07:02 PM

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.

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

HansF

Guest

n/a Posts

June 27th, 2008
07:02 PM
#2

Re: Empty string behaviour...

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

Quote:

Originally Posted by

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

Frank van Bortel

Guest

n/a Posts

June 27th, 2008
07:02 PM
#3

Re: Empty string behaviour...

krofak wrote:

Quote:

Originally Posted by

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

krofak

Guest

n/a Posts

June 27th, 2008
07:02 PM
#4

Re: Empty string behaviour...

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

Quote:

Originally Posted by

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

Quote:

Originally Posted by

>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

Not the answer you were looking for? Post your question . . .
182,494 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors