devxlogo

Converting Numbers into Words

Converting Numbers into Words

Ever written a PL/SQL block of code to convert numbers to words? Try this easy line of code to accomplish the same task:

SELECT TO_CHAR(TO_DATE(764,'J'), 'JSP') AS WORD_FORM FROM DUAL;

Here the ‘J’ option specifies that the conversion is to Julian format.

The result will be:

WORD_FORM------------------------SEVEN HUNDRED SIXTY-FOUR

devx-admin

Share the Post: