Re: changing a column type
- From: Gints Plivna <gints.plivna@xxxxxxxxx>
- To: kevin.lange@xxxxxxxxxx
- Date: Fri, 1 Jun 2012 23:46:49 +0300
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
Gints Plivna
http://www.gplivna.eu
2012/6/1 Lange, Kevin G <kevin.lange@xxxxxxxxxx>
> And to me, that's the strange thing.
>
> I can see allowing Character to varchar2.
> I can also see not allowing Character to Numeric.
>
> But why not allowing Numeric to Character ?
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
