Reply to thread

Message: <blockquote data-quote="mdee" data-source="post: 5334384" data-attributes="member: 218633">Oracle Function for SpellNumberHere is the script: --FUNCTION F_SpellNumber (In_Amt number)RETURN CHAR IS-- Spell Number a passed in, deimals are converted into digits in 100th-- By : mdee-- Version : 1.0 11-Feb-2006type myArray is table of varchar2(100);l_str myArray := myArray( '',' thousand ', ' million ',' billion ',' trillion ',' quadrillion ', ' quintillion ',' sextillion ', ' septillion ',' octillion ',' nonillion ',' decillion ', ' undecillion ',' duodecillion ' );l_num varchar2(100) default trunc(In_Amt);l_return varchar2(1000);l_deci_val varchar2(100);beginfor i in 1 .. l_str.countloopexit when l_num is null;if ( substr(l_num, length(l_num)-2, 3) <> 0 )thenl_return := to_char(to_date(substr(l_num, length(l_num)-2, 3),'J' ),'Jsp' ) || l_str(i) || l_return;end if;l_num := substr( l_num, 1, length(l_num)-3 );end loop;l_return := initcap(NVL(l_return,'xx'));if instr(In_amt,'.') > 0 thenl_deci_val := substr(In_Amt,instr(In_Amt,'.')+1,2);if length(l_deci_val)= 1 thenif l_deci_val >=1 and l_deci_val < 10 then-- Convert decimal tens with trailing zerol_deci_val := l_deci_val * 10;end if;end if;l_return := l_return || ' and '||(l_deci_val)||'/100';end if;l_return := l_return || ' only.';return(l_return);END; --Need any help please let me know. Try this: Select F_SpellNumber(12345678901234567890) from dual Twelve Quintillion Three Hundred Forty-Five Quadrillion Six Hundred Seventy-Eight Trillion Nine Hundred One Billion Two Hundred Thirty-Four Million Five Hundred Sixty-Seven Thousand Eight Hundred Ninety only. </blockquote>

Verification: Haya warak paha keeyada? (haya wadi kireema paha)

Top Bottom