decode(column,"1","Sun","2","Mon","3","Tue","4","Thu","5","Fri","6","Sta")

解决方案 »

  1.   

    to_char(Column_name,'Day',nls_date_language=AmerEnglish)
    是这样的吗?
    要怎样改啊?
      

  2.   

    select decode(columnName,'1','sun',...) from tableName where ...
      

  3.   

    SELECT DECODE(NUM,'1','MON','2','TUE','3','WED','4','THU','5','FRI','6','SAT','7','SUN') FROM TABLENAME T
      

  4.   

    OK?
    SQL>select to_char(sysdate,'Day','NLS_DATE_LANGUAGE = American') from dual
    SQL> /TO_CHAR(SYSDATE,'D
    ------------------
    Wednesday