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
Karma: 0
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: 25578
Registered: January 2009
Location: SoCal
Karma: 0
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
AskTom: Spell the number
And Barbara post one here.

Regards
Michel
Previous Topic: How does Java fit into PL/SQL-Oracle?
Next Topic: Query (merged 3)
Goto Forum:
  


Current Time: Tue Aug 22 12:00:36 CDT 2017

Total time taken to generate the page: 0.05261 seconds