RE: FW: Air pocket char fields.

From: <Joel.Patterson_at_crowley.com>
Date: Thu, 8 Dec 2011 08:51:41 -0500
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1B8BF18941_at_JAXMSG01.crowley.com>

I have read this, and I have his export oracle book.

However this classic discussion did not answer the question posed below, which is, why is oracle returning the answers it is returning as shown below?

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: Uwe Küchler [mailto:uwe_at_kuechler.org] Sent: Thursday, December 08, 2011 5:11 AM To: oracle-l
Cc: Patterson, Joel
Subject: Re: FW: Air pocket char fields.

This is one of the early classics on asktom: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:123212348063

Cheers,
Uwe

--
http://oraculix.wordpress.com/


Am Mi, 7.12.2011, 22:20, schrieb rjamya:


> perhaps 'blank padding' is coming into effect?

> Raj

>

> On Wed, Dec 7, 2011 at 3:51 PM, <Joel.Patterson_at_crowley.com> wrote:

>

>>

>> I sent this to a couple DBAs, which warranted it to be posted for

>> comment.

>>

>> Do you know why this is?  Shouldn't a CHAR field size 15 return all the

>> records where the field is 15 spaces when requested?   Should it not

>> return

>> all rows if <> anything but 15 spaces?

>>

>





--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 08 2011 - 07:51:41 CST