decode的使用

decode和case的功能相似，只是表达形式不一样

decode表达形式：

decode(col|expression,search1,result1

                                    [,search2,result2,...,]

                                    [,default])

 

例子：

select last_name,job_id,salary,

          decode(job_id,'it_prog',1.10*salary,

                                 'st_clerk',1.15*salary,

                                 'sa_sep',1.30*salary,

                      salary)

          revised_salary

from employees;