Re: FW: Air pocket char fields.

From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Thu, 08 Dec 2011 00:12:42 +0200
Message-ID: <4EDFE4DA.4050407_at_iki.fi>


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_at_crowley.com 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
Received on Wed Dec 07 2011 - 16:12:42 CST

Original text of this message