Win a copy of Head First Agile this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

oracle '5' to 'five'  RSS feed

 
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
Sheriff
Posts: 37261
519
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
Posts: 3752
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
Boost this thread!