Tuesday, September 30, 2014

Function for converting Number to Words

Syntax:
--------- 
TO_CHAR (TO_DATE (<VALUE>, 'j'), 'jsp')

egSELECT (TO_CHAR(TO_DATE (4566,'j'),'jsp')) num_to_words FROM DUAL;



Output: four thousand five hundred sixty-six