oracle里面where的条件及null值的判断

 where (case when a.settimeid is null then 1 else instr(to_char(ts.weekday), to_char(a.iday - 1, 'd')) end) > 0