Home » SQL & PL/SQL » SQL & PL/SQL » concert number to string like (1,one)
concert number to string like (1,one) [message #402458] Sun, 10 May 2009 14:39 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
Hi
i need to convert number to string like
1 ==> one ,
2 ==> two,
14 ==> Fourteen .... and so one

thanx
Rafeek
Re: concert number to string like (1,one) [message #402459 is a reply to message #402458] Sun, 10 May 2009 14:43 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+number+to+text+word
Re: concert number to string like (1,one) [message #402476 is a reply to message #402458] Mon, 11 May 2009 00:31 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AskTom: Spell the number
And Barbara post one here.

Regards
Michel
Previous Topic: Passing array from oracle procedure to javascript function
Next Topic: Query (merged 3)
Goto Forum:
  


Current Time: Fri Dec 09 02:14:06 CST 2016

Total time taken to generate the page: 0.08249 seconds