Number to Word Conversion

select to_char(to_date(:number,'j'),'jsp') from dual;





Examples




ELECT TO_CHAR (TO_DATE (234, 'j'), 'jsp') FROM DUAL;

//Output: two hundred thirty-four

SELECT TO_CHAR (TO_DATE (24834, 'j'), 'jsp') FROM DUAL;

//Output: twenty-four thousand eight hundred thirty-four

SELECT TO_CHAR (TO_DATE (2447834, 'j'), 'jsp') FROM DUAL;

//Output: two million four hundred forty-seven thousand eight hundred thirty-four