oracle自带数据库相关sql语句练习

点击打开链接

1.NVL

--找出不收取佣金或者是佣金低于100的雇员

解释：SELECT * FROM emp WHERE nvl(comm,0)<100

comm IS NULL  
SELECT * FROM emp WHERE comm is  null and 0<100 
comm IS NOT NULL 
SELECT * FROM emp WHERE comm IS NOT NULL and comm<100 

2.DECODE

SELECT 
       ename,
       job,
       sal,
       DECODE(JOB, 'CLERK', '业务员','SALESMAN','销售人员','MANAGER','经理','ANALYST','分析员','PRESIDENT','总裁') 职位  FROM emp;