Converting Number to Word

Problem:

How to convert number to word?

Example: You need to write po amount in a word format for a report.

98 >>> Ninety-eight

Solution:

You can use following package for this operation.

SELECT ap_amount_utilities_pkg.ap_convert_number(9815) AMOUNT FROM dual;

Probably, you want to take this query in your local language. If so, you must change your NLS_LANGUAGE first.

ALTER SESSION SET NLS_LANGUAGE = 'TURKISH';

Then,

SELECT ap_amount_utilities_pkg.ap_convert_number(9815) AMOUNT FROM dual;

Note: This package supports 12 digit most .

metanett