如何在这种情况下使用解码功能
DECODE(SomeParam,Value1,DECODE(SomeParam,Value2,1,2),1)
但情况更好:
case when someparam != Value1 then 1 whene someparam != Value2 then 2 else 1 end