This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

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: 3606
    
  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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: oracle '5' to 'five'
 
Similar Threads
Software Developers Drinking Song
Scrabble... it only takes a minute...
Tom's birthday
Oracle to buy Sun Microsystems..
Oracle JDBC unable to get connection