[oracle] Decode 과 case when 비교

decode( val

    ,'con1', 'value1',
    'con2', 'value2',
    'con3', 'value3',
    'default value' )

 

case val

       when 'con1' then 'value1'

       when 'con2' then 'value2'

       when 'con3' then 'value3'

       else 'default value'

end