解决方法
DECODE(SomeParam,Value1,DECODE(SomeParam,Value2,1,2),1)
但情况更好:
case when someparam != Value1 then 1 whene someparam != Value2 then 2 else 1 end
DECODE(SomeParam,Value1,DECODE(SomeParam,Value2,1,2),1)
但情况更好:
case when someparam != Value1 then 1 whene someparam != Value2 then 2 else 1 end