Re: '' IS NULL?

From: Richard J Bragg <richard.bragg_at_ntl.com>
Date: Mon, 11 Dec 2000 11:30:00 +0000
Message-ID: <3A34BAB8.9E09667@ntl.com>

But not for much longer.

"R. Dickhout" wrote:

> > >The options are:
> > >' ' a space
> > >'' a zero-length string
> > >(nothing) NULL
> > >
> >
> > ->SELECT * FROM Dual WHERE '' IS NULL;
> >
> > D
> > -
> > X
> >
> > It would seem that they are the same thing.
> >
> > Brian.

>
> They ARE the same thing. Oracle explicitly states that '' is NULL.
>
> Reinier.

Received on Mon Dec 11 2000 - 05:30:00 CST