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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
