NO NOT NULL NUMBER(4)Р?ENAME VARCHAR2(10)Р?JOB VARCHAR2(9)Р?MGR NUMBER(4)Р?HIREDATE DATEР?SAL NUMBER(7,2)Р?COMM NUMBER(7,2)Р?DEPTNO NUMBER(2) Р请写出以下操作的完整的SQL语句:(25分)Р1)、查询每个部门的工资总和。Рselect sum(sal) from empР2)、向EMP表中插入一条与SMITH内容相同的记录,但姓名改为Lida,雇员号改为7899。Рinsert (empno,ename,job,mgr,hiredate,m,depno) into emp values (select (7899,Lida,job,mgr,hiredate,m,depno) from emp where ename=’smith’)Р3)、将雇员Smith工资加$1000。Рupdate emp set sal=sal+1000 where ename=’Smith’Р4)、创建一张新表EMP2,把EMP表中工资大于$2000的雇员插入。Рcreate table emp2 ([EMPNO] [number](4) not null ,[ENAME] [VARCHAR2](10),[JOB] [VARCHAR2](9),[MGR] [number](4),[HIREDATE] [DATE],[SAL] [NUMBER](7,2),[COMM] [NUMBER](7,2),[DEPNO] [NUMBER](2))Рselect * into emp2 from emp where sal>2000Р5)、将EMP表增加一列AGE,用来存放雇员年龄。Рalter table emp add column [age] [number](4)
全文预览
