where (case when a.settimeid is null then 1 else instr(to_char(ts.weekday), to_char(a.iday - 1, 'd')) end) > 0
转载于:https://www.cnblogs.com/gaozhong98/archive/2009/11/06/1597211.html
转载于:https://www.cnblogs.com/gaozhong98/archive/2009/11/06/1597211.html