oracle按照in的顺序进行排序
select * from table_name where id in (1,3,7) order by case id when 1 then 1 when 3 then 2 when 7 then 3 end;