Re: Air pocket char fields.
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Thu, 08 Dec 2011 15:16:52 +0100
length(trim(stuff)) > 0
On 12/08/2011 02:57 PM, Joel.Patterson@xxxxxxxxxxx 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
