Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TRANSLATE Alfabet to Integer

Re: TRANSLATE Alfabet to Integer

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Wed, 13 Mar 2002 09:58:37 +1100
Message-ID: <KKvj8.2077$523.177088@ozemail.com.au>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US