数值函数
Round
select round(412,-2) from dual;
select round(412.313,2) from dual;
Mod
Trunc
select trunc(412.13,-2) from dual;
日期函数
Months_between()
select months_between(sysdate,hiredate) from emp;
Add_months()
select add_months(sysdate,1) from dual;
Next_day()
select next_day(sysdate,'星期一') from dual;
Last_day
select last_day(sysdate) from dual;
CUUG 优技培训
金牌讲师
实操环境
院校合作
学校新闻
行业新闻
请输入您的手机号
申请试听