Home » Developer & Programmer » Forms » spell number to word in arabic (oracle 6i,database 9i,xp)
spell number to word in arabic [message #412444] Thu, 09 July 2009 07:09 Go to next message
hisham99
Messages: 86
Registered: October 2008
Location: united arab emirates
Member
i know how to spell number to english
SELECT to_CHAR(to_DATE(ROUND(1439.45),'J'),'JSP')
"word" FROM DUAL

but i need to spell number to arabic?
Re: spell number to word in arabic [message #412448 is a reply to message #412444] Thu, 09 July 2009 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No built-in, you have to write (or find) your own function.

Regards
Michel

[Updated on: Thu, 09 July 2009 07:20]

Report message to a moderator

Re: spell number to word in arabic [message #412453 is a reply to message #412444] Thu, 09 July 2009 08:16 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Well,
Download the zip file. Because you know arabic so you can change it according to your requirement I hope. I downloaded this file from the following link.

https://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=511&lngWId=5

If you open it in notepad, it'll not show you arabic. Open it in wordpad and then copy and paste the function in sqlplus. It works and returns the output in arabic not in english.

regards,
Saadat Ahmad
Re: spell number to word in arabic [message #412454 is a reply to message #412444] Thu, 09 July 2009 08:18 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Here's the screenshot of the output
./fa/6498/0/

[Updated on: Thu, 09 July 2009 08:19]

Report message to a moderator

Previous Topic: Centralizing forms.
Next Topic: functionality of when-validate-item trigger
Goto Forum:
  


Current Time: Fri Dec 02 23:05:18 CST 2016

Total time taken to generate the page: 0.16530 seconds