aspose file tools*
The moose likes Oracle/OAS and the fly likes oracle '5' to 'five' Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "oracle Watch "oracle New topic
Author

oracle '5' to 'five'

praneeth ram
Ranch Hand

Joined: Sep 21, 2009
Posts: 60
Hi,

I want to convert number '5' to its corresponding string 'Five'. can any one please tell me oracle funcition for this requirement.

Thanks,
Praneeth.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30764
    
156

Can you clarify your requirement. Do you just want to convert the number 5. Or do you want to convert numbers form 0-9,. 1-9, 1-100, etc.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

This is quite comprehensive discussion about converting numbers to their textual representation in Oracle, including languages other than English.
Rene Argento
Greenhorn

Joined: Jun 09, 2010
Posts: 10
You might also want to take a look at the REPLACE and REGEXP_REPLACE functions.


SCJA | SCJP6 | OCE SQL | OCA DBA 10g
 
jQuery in Action, 2nd edition
 
subject: oracle '5' to 'five'