关于Oracle的查询条件的自定义顺序
select EMP_ID from org_employee where useraccounts in ('xxx6530','xxx1527','xxx0323','xxx2718')
and userIsDeleted=0 and USERISACTIVE=1 order by INSTR('xxx6530,xxx1527,xxx0323,xxx2718',useraccounts);
如果不加 order by INSTR('xxx6530,xxx1527,xxx0323,xxx2718',useraccounts);查询的结果就没有顺序了