Re: changing a column type

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 01 Jun 2012 15:50:51 -0600

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-l


Other related posts: