On Friday 18 June 2004 16:21, Ann W. Harrison wrote:

Hi,

> I was surprised that the article suggested this was new.
> As far as I know, Oracle has never distinguished between
> an empty string and a null value.

I have just run that example in Oracle 8i and it does as I expect, and not as
the article describes. Maybe it was introduced in v9 or it can be turned off
or something (I will have to ask one of our DBA's)

Phil

--
Discover a lost art - play Marbles
May 2004
www.marillion.com
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | pjshrimpton@...