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
Showing posts with label Queries and Terms. Show all posts
Showing posts with label Queries and Terms. Show all posts
Saturday, June 19, 2010
Subscribe to:
Posts (Atom)