View Single Post

   
  #4 (permalink)  
Old 04-07-2008, 10:07 AM
Ms. D.H. Harvey
 
Posts: n/a
Default Re: Translation Number to full text

,philippe <hay_tray@yahoo.fr> wrote:
: Thanks Helen

: but is it possible to get it in Spanish or an other language?

: if I wrote
: select to_char(to_date('15','J'),'Jsp','NLS_DATE_LANGUAGE = SPANISH') from
dual;

: I get
: Fifteen
: and I want to get
: Quince

Take a look at:

http://asktom.oracle.com/pls/ask/f?p...:NO::F4950_P8_
DISPLAYID,F4950_P8_CRITERIA:1407603857650,

This line will wrap and need to be joined back up.

HTH Helen

/\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\
( oo ) ( oo ) ( oo ) ( oo ) ( oo ) ( ** ) ( oo ) ( oo ) ( oo ) ( oo ) ( oo )
=^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^=
Reply With Quote