| Author |
oracle '5' to 'five'
|
praneeth ram
Ranch Hand
Joined: Sep 21, 2009
Posts: 56
|
|
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: 23635
|
|
|
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]
Certs: SCEA Part 1, Part 2 & 3 & Core Spring 3, OCAJP
|
|
Martin Vajsar
Bartender
Joined: Aug 22, 2010
Posts: 1217
|
|
|
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
|
|
 |
|
|
subject: oracle '5' to 'five'
|
|
|
0
