select ename,hiredate,to_char(hiredate,'DAY') from emp;
这个order by 应怎写啊?
ENAME HIREDATE DAY
---------- --------- ---------
KING 17-NOV-81 MONDAY
MILLER 23-JAN-82 FRIDAY
BLAKE 01-MAY-81 THURSDAY
CLARK 09-JUN-81 MONDAY
JONES 02-APR-81 WEDNESDAY
05TIN 28-SEP-81 SUNDAY
ALLEN 20-FEB-81 THURSDAY
TURNER 08-SEP-81 MONDAY
WARD 22-FEB-81 SATURDAY
FORD 03-DEC-81 WEDNESDAY
SMITH 17-DEC-80 TUESDAY