摘要：
--函数 founations()SQL> select ename,empjob,sal 涨前薪水, decode(empjob,'PRESIDENT',sal+1000, 2 'MANAGER',sal+800, 3 sal+400) 涨后薪水 4 from emp; select ename,empjob,sal 涨前薪水, case empjob when 'PRESIDENT' then sal+1000 2 when 'MANAGER' then sal+800 3 else sal+400 4 end 涨后薪水 阅读全文
