Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NUMBER TO WORDS
I NEED TO KNOW HOW CAN I CHANGE DE LANGUAGE OF THE RESULT OF
THIS SQL:
select to_char(to_date(123,'J'),'jsp') from dual
RETURNS
one hundred twenty-three
I WANT THE RESULT IN ANOTHER LANGUAGE LIKE SPANISH:
CIENTO VEINTI TRES
WHAT I NEED TO CHANGE ON THE CLIENT OR ON THE SERVER
TANK YOU