Re: Length of empty string?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 02 May 1998 13:24:40 GMT
Message-ID: <01bd75cc$5d6721a0$0300a8c0@WORKSTATION>

Remember though that Oracle has been warning us for years that they will eventually get around to treating zero length strings as different from nulls.

Bill Bearden <bbearden_at_bcl.net> wrote in article <01bd75c6$6af8b320$94bccecf_at_bbearden>...
> There really isn't an 'empty string' in Oracle. You are testing
the length
> of NULL. Just about any operation on NULL returns NULL.
>
> Personally, I disagree with this behavior. Coming from a more
traditional
> programming background, I think of '' as the empty string. But in
> SQL/PLSQL class, the instructor went out of his way to point this
> distinction out.
>
Received on Sat May 02 1998 - 08:24:40 CDT