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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sun, 26 Aug 2007 08:26:12 -0700
Message-ID: <1188141972.346706.222340@y42g2000hsy.googlegroups.com>


On Aug 26, 2:17 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> NULL <> NULL, but '' = '', if that would help.
> The length of NULL is NULL again.

If we had a '' in Oracle then its length would be 0, but we don't, which is the subject of this thread. I was hoping someone could provide an example of non-null '' being a useful value. Received on Sun Aug 26 2007 - 10:26:12 CDT

Original text of this message

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