Contact Us

Saturday, June 19, 2010

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

No comments:

Post a Comment

Give your comments or suggestions here.