7—oracle的函数

《7—oracle的函数》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、上图答案：selectlower(ename)fromemp;selectupper(ename)fromemp;select*fromempwherelength(ename)=5;selectsubstr(ename,1,3)fromemp;selectupper(substr(ename,1,1))

2、

3、lower(substr(ename,2,length(ename)-1))fromemp;｛第一步：完成首字母大写：selectupper(substr(ename,1,1))fromemp;第二步：完成后边字母的小写：selectlower(substr(ename,2,length(

4、ename)-1))fromemp;第三步：合并。｝selectlower(substr(ename,1,1))

5、

6、upper(substr(ename,2,length(ename)-1))fromemp;5selectreplace(ename,'A',’a’)fromemp;5selecttrunc(sal/30),enamefromemp;上图答案：select*fromempwheresysdate>add_months(hiredate,8);select*fromempwheresysdate>add_months(hiredate,12*10);selectsysdate-hi

7、redate"入职天数",enamefromemp;select*fromempwherelast_day(hiredate)-2=hiredate;5selectenamefromempwhereto_char(hiredate,'yyyy')=1980;selectenamefromempwhereto_char(hiredate,'mm')=12;55