OraFAQ Forum: Forms » spell number to word in arabic

Home » Developer & Programmer » Forms » spell number to word in arabic (oracle 6i,database 9i,xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spell number to word in arabic [message #412444]

Thu, 09 July 2009 07:09

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior 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?

Report message to a moderator

Re: spell number to word in arabic [message #412448 is a reply to message #412444]

Thu, 09 July 2009 07:20

Michel Cadot
Messages: 68686
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

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