As we all know We can convert number into words Using ‘Jsp’ format string in to_char function. ind> select to_char(to_date(‘250′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘ —————– TWO HUNDRED FIFTY 1 row selected. ind> select to_char(to_date(‘259′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘259’, ———————- TWO HUNDRED FIFTY-NINE 1 row selected. ind> select to_char(to_date(‘9999′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘9999′,’J’),’JSP’) ————————————– NINE THOUSAND NINE HUNDRED NINETY-NINE … Continue reading Spell number In Indian Currency System Using Function (Number into words)