Monday, March 21, 2011

Display Numbers in Figures useing AP Module AP_Convert_number Function

In AP Module there is a builtin Function (ap_amount_utilities_pkg.ap_convert_number )to convert number value into Figures.

Example :-

SELECT Upper(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words  FROM DUAL  -- For Upper Case Letters

SELECT InitCap(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words  FROM DUAL -- For Mixed Case Letters

SELECT Lower(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words  FROM DUAL -- For Lower Case Letters

No comments:

Post a Comment