Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TRANSLATE Alfabet to Integer
select ascii(upper('&alpha'))-64
from dual;
Ray
"R Chin" <rchin_at_panix.com> wrote in message
news:a6lt7t$h31$1_at_reader2.panix.com...
> Select TRANSLATE(CALLIND,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','123456789..')
>
> I want to TRANSLATE alfhabets into sequential integers....ie. J --> 10
etc,
> can this be done ?
>
> thanks
> Robert Chin
>
>
Received on Tue Mar 12 2002 - 16:58:37 CST
![]() |
![]() |