Re: changing a column type
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 01 Jun 2012 15:50:51 -0600
Message-ID: <4FC9393B.3040008_at_gmail.com>
Yes, both number and date store each digit individually, two to a byte, in modified Binary Coded Decimal. Sort-a tells you when the design was locked in. If you remember BCD ... :-)
Date: Fri, 01 Jun 2012 15:50:51 -0600
Message-ID: <4FC9393B.3040008_at_gmail.com>
Yes, both number and date store each digit individually, two to a byte, in modified Binary Coded Decimal. Sort-a tells you when the design was locked in. If you remember BCD ... :-)
/Hans
On 01/06/2012 2:46 PM, Gints Plivna wrote:
> Most probably because the internal representation of Number datatype is
> muuuuuuuch different than that of char and varchar2. You can get some
> insight for example here
> http://www.ixora.com.au/notes/number_representation.htm
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 01 2012 - 16:50:51 CDT