![]() L_return := L_return || Digits3_To_Word(V_inp_Dec) ||' Cents' Concatenate the word for decimal digits L_Return := 'Dollar '||L_Return ||' and ' L_Return := Digits3_To_Word(V_Temp) || In_str(m) || L_Return Type LionArray is table of Varchar2(500) V_temp := LPAD(to_char(V_inp_number),3,0) Ĭreate or replace function NUM_TO_WORD (P_inp_num in NUmber) This function return word equivalent to its number We just need to ignore that - the if statement added takes care of that.Ĭreate or replace function Digits3_To_Word (P_number in number) forgot to take into consideration the possibility of 000 as part of a number. #ONE TWO THREE FOUR SPELLING CODE#PL/SQL procedure successfully to comment about 1000Ĭorrect, the code is updated to reflect that. Hundred Forty million Eight Hundred Twenty-Two Trillion Two Hundred Ninety-Two billion Five Trillion Three Hundred Eleven billion Nine millionįour Hundred Seventeen thousand Six Hundredġ39,292,540,822,249 - One Hundred Thirty-Nine Ninety-Eight million Three Hundred Twenty-Nineġ55,311,009,417,668 - One Hundred Fifty-Five Trillion Six Hundred Fifty-Two billion Six Hundred Ninety-Four thousand Nine Hundred Eighty-Nineġ37,652,698,329,777 - One Hundred Thirty-Seven Hundred Twenty-Nine million Three Hundred Fourteenħ,789,111,094,989 - Seven trillion Seven HundredĮighty-Nine billion One Hundred Eleven million Trillion Seven Hundred Sixty-One billion Seven Hundred Fifty-Nine million One Hundred Thirty-Oneġ78,761,729,314,960 - One Hundred Seventy-Eight ![]() Trillion Eight Hundred Eighty-One billion Seven Million Three Hundred Eighty-Four thousand Threeġ48,881,759,131,997 - One Hundred Forty-Eight Hundred Twenty-One billion One Hundred Sixty-Nine ![]() Two Hundred Two billion Twenty-Five million FourĢ8,221,169,384,374 - Twenty-Eight trillion Two Hundred Thirty-One billion One Hundred SixtyĢ10,202,025,424,018 - Two Hundred Ten trillion ![]() Red Eighty-Nine billion Twelve million Three HundrĮd Forty-Five thousand Six Hundred declareġ2 to_char( l_num, '999,999,999,999,999,999' ) ģ12,051,345,415,411 - Three Hundred Twelveįorty-Five million Four Hundred Fifteen thousandĢ5,131,160,032,468 - Twenty-Five trillion One Rillion Four Hundred Fifty-Six trillion Seven Hund N Five Hundred Sixty-Seven sextillion Eight Hundreĭ Ninety quintillion One Hundred Twenty-Three quad Ion Six Hundred Seventy-Eight nonillion Nine HundrĮd One octillion Two Hundred Thirty-Four septillio Twelve undecillion Three Hundred Forty-Five decill ![]() Sure, with a little effort - you can use the J -> Jsp trick and do it create or replaceĢ function spell_number( p_number in number )ĥ type myArray is table of varchar2(255) ġ5 l_num varchar2(50) default trunc( p_number ) Ģ2 if ( substr(l_num, length(l_num)-2, 3) 0 )ģ0 l_num := substr( l_num, 1, length(l_num)-3 ) Ģ spell_number( 12345678901234567890123456789012345678 ) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |