Re: numeric to fully-written-numbers pl/sql translator
Date: Mon, 14 Jun 1999 16:41:50 +0100
Message-ID: <37652066.0_at_145.227.194.253>
Try this, i'm not sure about other languages though. This kind of procedure is dotted around various web sites so you may find another language somewhere.
- Cut Here ===============
Function Spell (v_number in number) return varchar2 is
v_word varchar2(1000);
begin
select to_char(to_date(v_number,'j'), 'Jsp')
into v_word
from dual;
return v_word;
end;
- END ===============
Guy Hendrickx wrote in message <7k36da$glv$1_at_naxos.belnet.be>...
>Hi,
>I'm looking for a pl/sql procedure which is capable of translating
>a numeric value to a full-text string :
>ex. '20' will become 'twenty'.
>If possible it should be available for Ducth, French and English.
>If only one of the above languages is supported, I'm still interested.
>Kind regards,
>Guy Hendrickx
>Guy_at_Cereus.BE
>
>
Received on Mon Jun 14 1999 - 17:41:50 CEST