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;
原文：http://www.cnblogs.com/gavinYang/p/4149905.html
