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