Oracle经典练习题和标准答案.docxVIP

oracle经典练习sql/*1、选择在部门30中员工的所有信息*/ select * from scott.emp where deptno = 30 /*2、列出职位为（MANAGER）的员工的编号，姓名 */ select empno, ename from scott.emp where job = MANAGER /*3、找出奖金高于工资的员工*/ select * from scott.emp where comm sal /*4、找出每个员工奖金和工资的总和 */ select ename, sal + nvl(comm, 0) from scott.emp /*5、找出部门10中的经理(MANAGER)和部门20中的普通员工(CLERK) */ select * from scott.emp where deptno = 10 and job = MANAGER unionselect * from scott.emp where job = CLERK and deptno = 20 /*6、找出部门10中既不是经理也不是普通员工，而且工资大于等于2000的员工 */ select * from scott.emp where job != MANAGER and job != CLERK and sa