Conversion of NUMBER to WORDS
Posted on 2001-09-10
Hi there !!
I want to write a function or procedure which accepts a decimal number as its arguement and returns the same number translated into words.
The procedure should give me the following output for given inputs :
1) INPUT : 2300.34
OUTPUT : Rupees Two Thousand Three Hundred and Paise Thirty Four Only.
2) INPUT : 1523420.25
OUTPUT : Rupees Fifteen Lacs Twenty Three Thousand Four Hundred Twenty and Paise Twenty Five Only.
3) INPUT : 23455255.00
OUTPUT : Rupees Two Crore Thirty Four Lacs Fifty Five Thousand Two Hundred Fifty Five and Paise Zero Only.
Here the maximum number I will input will be 99999999.99 and there will be only 2 decimal places. The number before the decimal point is RUPEES and the number after the decimal point is PAISE.
I have tried a lot but I am unable to get it. Please send me the PL/SQL for this procedure.