SQL & PL/SQL

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!

Converting a number into world In spanish Language

108332Apr 15 2003 — edited Jun 15 2004

Hi Gurus

I am using database in Spanish Language and character Set.
MY database is medium size but when I use following query
I get out put in English Language

select to_char(to_date(1,'JSP'),'JSP') from dual

output as
ONE

How can I get this output in spanish Language
such as
UNO , DOS ect...

Help me pLease

Bhushan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2004

Added on Apr 15 2003

9 comments

2,028 views