Re: changing a column type

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


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


Other related posts: