3-15记录

Oracle的初步了解：

         select * from emp where empno = 10;

        select empno,feptno from emp order byempno desc,deptno asc;

        select sal 调前,case job when ‘PRESIDENT‘ then sal + 1000 when ‘MANAGER‘ then sal + 800  else sal + 400 end 涨后 from emp;

        select sal ,decode(job,‘PRESIDENT‘,sal+ 1000,‘MANAGER‘,sal+800,sal+400) from emp;

3-15记录

原文：http://www.cnblogs.com/savepoint/p/5282121.html