oracel 条件包含 instr in
instr('FL01/FL03/FL05/',dep_code||'/')> 0 --等于: dep_code in ('FL01','FL03','FL05') and dep_code is not NULL --注意:instr对空数据不起作用,非空字段记得添加非空判断
instr('FL01/FL03/FL05/',dep_code||'/')> 0 --等于: dep_code in ('FL01','FL03','FL05') and dep_code is not NULL --注意:instr对空数据不起作用,非空字段记得添加非空判断