Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to translate Numbers to Spanish

xrys9023720Feb 15 2012 — edited Feb 15 2012
Hi -

Can please anyone help me?

How can I convert/translate word numbers to Spanish? Example, instead of "twenty" it will be "veinte" or "Seven Thousand four hundred and fifty five" to "Siete mil cuatrocientos cincuenta y cinco"?

Currently this is what i have so far,


SELECT TO_CHAR (TO_DATE (10, 'YYYY'), 'Yyyysp')
FROM DUAL;

But this will only convert 10 to Ten. I need to convert the word "TEN" to "Diez".

Please!

Your help will be very much appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2012
Added on Feb 15 2012
4 comments
406 views