• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle '5' to 'five'

 
praneeth ram
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Martin Vajsar
Sheriff
Pie
Posts: 3751
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is quite comprehensive discussion about converting numbers to their textual representation in Oracle, including languages other than English.
 
Rene Argento
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might also want to take a look at the REPLACE and REGEXP_REPLACE functions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic