Convert Number into Amount in words.
There were some thread longtime back, and they were looking for some xsl function , that can convert the number in to Words.. The great Gareth, gave a suggestion to use package from database & convert into the words :).. -------------------------------------------------------------------------------- Use ap_amount_utilities_pkg.ap_convert_number E.g. SQL> select ap_amount_utilities_pkg.ap_convert_number(trunc(12345678)) from dual; AP_AMOUNT_UTILITIES_PKG.AP_CONVERT_NUMBER(TRUNC(12345678)) -------------------------------------------------------------------------------- Twelve million three hundred forty-five thousand six hundred seventy-eight http://sureshvaishya.blogspot.com/2008/03/display-numbers-in-figures.html -------------------------------------------------------------------------------- Another person with great though Frank Greene, can the Oracle BI Publisher access a PL/SQL stored package.function at run time and return a val...