Home » SQL & PL/SQL » SQL & PL/SQL » Translate Number value to Character
Translate Number value to Character [message #277209] Mon, 29 October 2007 04:27 Go to next message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

Please tell me how to translate a number value to a character value in Oracle 8i and 9i.

Example:

10000 will be translated as

"Ten Thousand rupees only"


Regards

Nadeem Rafiq
Re: Translate Number value to Character [message #277211 is a reply to message #277209] Mon, 29 October 2007 04:33 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And what happened when you searched for "spell number"? Try and find out...

MHE
Re: Translate Number value to Character [message #277222 is a reply to message #277209] Mon, 29 October 2007 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why "only"? Very Happy

Regards
Michel
Re: Translate Number value to Character [message #277228 is a reply to message #277209] Mon, 29 October 2007 04:59 Go to previous messageGo to next message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

Please Reply me soon. Why you tease youngsters.


Nadeem
Re: Translate Number value to Character [message #277232 is a reply to message #277228] Mon, 29 October 2007 05:09 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
We only tease people who don't seem to understand simple instructions like

Quote:

And what happened when you searched for "spell number"? Try and find out...
Re: Translate Number value to Character [message #277233 is a reply to message #277232] Mon, 29 October 2007 05:15 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I tried searching for it and got this result.

Nadeem, you should have read the forum guide. If you did, you would have known that there is a search facility on the forum that works quite well.

MHE

[edit]added link to forum guide.

[Updated on: Mon, 29 October 2007 05:17]

Report message to a moderator

Re: Translate Number value to Character [message #277271 is a reply to message #277209] Mon, 29 October 2007 06:29 Go to previous message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

Thanks Sir
Previous Topic: Does The Query get Fired Again
Next Topic: Need Help for query checking douplicate values
Goto Forum:
  


Current Time: Thu Dec 08 23:59:27 CST 2016

Total time taken to generate the page: 0.05892 seconds