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


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

Follow-Ups:

Re: changing a column type
From: Hans Forbrich

References:
- changing a column type
  - From: Zelli, Brian
- RE: changing a column type
  - From: Powell, Mark
- RE: changing a column type
  - From: Zelli, Brian
- Re: changing a column type
  - From: David Fitzjarrell
- RE: changing a column type
  - From: Lange, Kevin G

Re: changing a column type

Other related posts: