oracle數(shù)據(jù)庫應(yīng)用與開發(fā)教材課后習題參考答案(編輯修改稿)
2025-07-25 08:33 本頁面
【文章內(nèi)容簡介】 o course values(39。100139。,39。文學39。,39。8839。)。insert into course values(39。100239。,39。文學39。,39。9939。)。insert into course values(39。100139。,39。經(jīng)濟39。,39。8939。)。.c)insert into score values(39。00139。,39。100139。,39。639。)。insert into score values(39。00139。,39。100139。,39。739。)。insert into score values(39。00239。,39。100139。,39。839。)。d) update score set sno=39。00339。 where grade=39。839。update score set o=39。100339。 where sno=39。00239。e) delete from student where sname=39。lisi39。4.a) 管理方案表在“方案”和“對象名”文本框中輸入要刪除的方案名或表名，選擇需要刪除的表，單機“刪除”。b) drop table student。 習題1. AB 2. B 3 C 4. A 5. B 6. C 7 A 8 C 9. B 10. A 實驗(1) select * from where deptno=20。(2) select empno,ename,deptno from where job=39。CLERK39。(3) select * from where msal。(4) select * from where msal*。(5) select * from where (deptno=10 and job=39。MANAGER39。) or (deptno=20 and job=39。CLERK39。)。(6) select * from where job not in(39。MANAGER39。,39。CLERK39。) and sal=2000。(7) select * from where m is not null。(8) select count(empno),avg(sal) from 。(9) select * from where m is null or m100(10) select * from where (sysdatehiredate)/365=2。(11) select * from where (sysdatehiredate)/365=10。(12) select initcap(lower(ename)) from 。(13) select * from where length(ename)=6。(14) select * from where ename not like 39。%S%39。(15) select * from where ename like 39。_M%39。(16) select substr(ename,1,3) from 。(17) select replace(ename,39。s39。,39。S39。) from 。(18) select ename,hiredate from order by hiredate。(19) select ename,job,sal from order by job desc,sal asc。(20) select ename,extract(year from hiredate) as 年份,extract(month from hiredate) as 月份 from order by 月份,年份。(21) select deptno,count(*),avg(sal),avg((sysdatehiredate)/365) from group by deptno。(22) select count(*),avg(sal) from group by deptno。(23) select min(sal),job from group by job having min(sal)3000。(24) select deptno,job,max(sal) from group by deptno,job。(25) select count(*),avg(sal) from group by job。 習
研究報告相關(guān)推薦
鄂ICP備17016276號-1