Re: changing a column type
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 1 Jun 2012 23:46:49 +0300
Message-ID: <CAN2wOq3KGmFvZGNbi3LcjSVEp7UHGN5QxQJ9p-sDUb00BJMcTQ_at_mail.gmail.com>
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
Date: Fri, 1 Jun 2012 23:46:49 +0300
Message-ID: <CAN2wOq3KGmFvZGNbi3LcjSVEp7UHGN5QxQJ9p-sDUb00BJMcTQ_at_mail.gmail.com>
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_at_ppoone.com>
> 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-lReceived on Fri Jun 01 2012 - 15:46:49 CDT