Oracle R12 : Converting Number into words ( trick )

This is not very regular but kind of very good trick. How to Convert number into strings.  Here is a standard Oracle Package , generally used in AP side but can be use in your code also.

Solution:
SELECT ap_amount_utilities_pkg.ap_convert_number(12345) AS amt_in_words    FROM dual;

Output:
AMT_IN_WORDS

———————

Twelve thousand three hundred forty-five

We used this in some localized reports  and check printing.