Re: FW: Air pocket char fields.

From: Timo Raitalaakso <rafu@xxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 08 Dec 2011 00:12:42 +0200

select 1 from dual where '' is null;

select 1 from dual where trim('   ') is null;

--
Timo Raitalaakso
http://rafudb.blogspot.com/

7.12.2011 22:51, Joel.Patterson@xxxxxxxxxxx kirjoitti:
> select count(*) ONE from lawcrp.mmdist where activity = ' ';
>
>         ONE
> ----------
>     3744244
>
> select count(*) ZERO from lawcrp.mmdist where activity = '';
>
>        ZERO
> ----------
>           0
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
>

--
http://www.freelists.org/webpage/oracle-l

References:

FW: Air pocket char fields.
From: Joel.Patterson

Re: FW: Air pocket char fields.

Other related posts: