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.