Re: Air pocket char fields.
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 08 Dec 2011 15:16:52 +0100
Message-ID: <4EE0C6D4.9060801_at_roughsea.com>
length(trim(stuff)) > 0
Date: Thu, 08 Dec 2011 15:16:52 +0100
Message-ID: <4EE0C6D4.9060801_at_roughsea.com>
length(trim(stuff)) > 0
On 12/08/2011 02:57 PM, Joel.Patterson_at_crowley.com wrote:
> I suspect oracle is padding the literal automatically because it knows it is a char().
>
> So it returns 3million when = '<any#ofSpaces>' and 700k when<> '<any#ofspaces>'.
>
> So if somebody only wants a result set that has data in that field, (no blanks), and the field is a NOT NULL column, then the best way to eliminate those records is?
>
> Joel Patterson
> Database Administrator
> 904 727-2546
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 08 2011 - 08:16:52 CST