Convert Number into Words

select ename,sal,to_char(to_date(sal,’J’), ‘JSP’) as converted_form
from scott.emp

ENAME SAL CONVERTED_FORM
SMITH 800 EIGHT HUNDRED
ALLEN 1600 ONE THOUSAND SIX HUNDRED
WARD 1250 ONE THOUSAND TWO HUNDRED FIFTY
JONES 2975 TWO THOUSAND NINE HUNDRED SEVENTY-FIVE
MARTIN 1250 ONE THOUSAND TWO HUNDRED FIFTY
BLAKE 2850 TWO THOUSAND EIGHT HUNDRED FIFTY

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply