EasyDemo*Oracle常见函数

一、字符函数

select lower(ename),sal from emp;
select upper(ename),sal from emp;
select * from emp where length(ename)=5;
select substr(ename,1,3) from emp;//从姓名的第一位截取，截取姓名的三位

select replace(ename,'A','我是A') from emp;//A:找那个;我是A替换成

二、数学函数

select (round(sal)+round(comm))*13 from emp;
select (round(sal))*13 from emp where ename='SCOTT';
select round(sal,1) from emp where ename='SCOTT';//保留一位小数
select trunc(sal,1),sal from emp where ename='SCOTT'; 
select floor(sal),sal from emp where ename='SCOTT'; 

三、日期函数

select sysdate from emp;
select * from emp where sysdate>add_months(hiredate,8);
select hiredate,last_day(hiredate) from emp;

四、转换函数

select ename,to_char(hiredate,'yyyy-mm-dd hh24:mi:ss'),to_char(sal,'L99999.99') from emp;

五、系统函数