oracle 查询in操作 查询结果按in集合顺序显示
?问题如下：
select?*?from?tfm_services?t?where?t.service_name?in?('QueryAdviceConfigService'
,'ResetAdviceListState'????
,'CancelAdviceListState'
,'GetSMSCharLimit'
,'SendSMSService'
,'AddAdviceType'
,'ModAdviceType'
,'DelAdviceType'
,'DelAdviceTypeLang'
,'AddAdviceTypeLang');
?
查询出来的结果如何按照我传递参数的顺序显示出来，而不是按照service_name的首字母顺序排列
?
有一个办法，不过比较麻烦。
SQL如下：
?
select * from tfm_services t where t.service_name in (
'QueryAdviceConfigService'
,'ResetAdviceListState' ? ?
,'CancelAdviceListState'
,'GetSMSCharLimit'
,'SendSMSService'
,'AddAdviceType'
,'ModAdviceType'
,'DelAdviceType'
,'DelAdviceTypeLang'
,'AddAdviceTypeLang')
ORDER BY decode(t.service_name,'QueryAdviceConfigService',1,
'ResetAdviceListState',2,
'CancelAdviceListState',3,
'GetSMSCharLimit',4,
'SendSMSService',5
,'AddAdviceType',6
,'ModAdviceType',7
,'DelAdviceType',8
,'DelAdviceTypeLang',9);
