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 ...  :-)


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

Other related posts: