SQL> select decode(to_char(sysdate,'D'),1,'Mon',6,'Fri') from dual;DECODE(TO_CHAR(SYSDATE,'D'),6,
------------------------------
Fri
你把周2、3.....加上就可以了
------------------------------
Fri
你把周2、3.....加上就可以了
调试欢乐多
FROM DUALSELECT TO_CHAR(SYSDATE, 'Day','nls_date_language = english')||'''s Special' "Menu"
FROM DUAL
------------------------------
fri