Database Administration (MOSC)

MOSC Banner

NLS Parameters - Numeric to Words in Spanish

edited Dec 11, 2008 1:50AM in Database Administration (MOSC) 2 comments
Hello,

 

I'm working on a Border/Baja project where we are required to spell out the dollar amounts...  I'm using the sql statement

 

select to_char(to_date(1243,'j'), 'jsp') from dual
                                            
                                                      
TO_CHAR(TO_DATE(1243,'J'),'JSP')                      
------------------------------------                  
one thousand two hundred forty-three                  

Which works great in English...

However, they are requiring us to spell it out in Spanish on our invoices.  Is there a way to do this easily changing a NLS parameter?

I basically need to convert that result to...

mil doscientos cuarenta y tres

 

Any advice would be great,

 

Thanks,

 

Chris

 

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center