Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Empty string behaviour...

Re: Empty string behaviour...

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 21 Oct 2005 19:14:52 +0200
Message-ID: <djb75m$46s$1@news2.zwoll1.ov.home.nl>


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...
Received on Fri Oct 21 2005 - 12:14:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US