Oracle 常用函数实例总结

来源：互联网发布：linux更改文件权限777 编辑：程序博客网时间：2024/06/06 13:01

<pre class="sql" name="code">--TO_CHAR函数    SELECT empno, ename, TO_CHAR(sal, '$999,999.00') FROM emp; --查询员工薪水加入千分位和保留两位小数--NVL函数 NVL(表达式1，表达式2):将该字段的null转换成表达式2的值SELECT empno, ename, sal, comm, sal+NVL(comm,0) FROM emp; --取得员工的全部薪水--CASE　WHEN  THEN  WHEN  THEN  ELSE END函数SELECT empno, ename, job, sal, (--如果job为MANAGERG薪水上涨10%,如果job为SALESMAN工资上涨50%CASE jobWHEN 'MANAGER'  THEN sal*1.1WHEN 'SALESMAN' THEN sal*1.5ELSE  salEND)  AS newsalFROM emp;--DECODE 函数SELECT empno, ename, job, sal, --如果job为MANAGERG薪水上涨10%,如果job为SALESMAN工资上涨50%DECODE(job,'MANAGER' , sal*1.1,'SALESMAN', sal*1.5,  sal) AS newsalFROM emp;--日期函数SELECT to_char(ADD_MONTHS(to_date('20150129','yyyymmdd'),1),'yyyymmdd') AS FAIL_DATE FROM dual--ROUND 函数SELECT ROUND(123.45, -1) FROM dual;      --120

0 0