【多选题】下列说法正确的是
A. v emp%rowtype; select * into v from emp where empno=7788; 上面代码是正确的。 B. v emp%type; select * into v from emp where empno=7788; 上面代码是正确的。 C. v emp.empno%type; select * int
A. v emp%rowtype; select * into v from emp where empno=7788; 上面代码是正确的。 B. v emp%type; select * into v from emp where empno=7788; 上面代码是正确的。 C. v emp.empno%type; select * int
举一反三
- 查询员工表emp中的第3条到第8条记录。显示emp表中的全部字段。( ) A: select rownum rn,emp.* from emp where rownum3; B: select * from(select rownum RN,emp.* from emp where RN3; C: select * from(select rownum RN,emp.* from emp where rownum3; D: select rownum RN,emp.* from emp where RN3;
- 以下语句不正确的是( ) A: select * from emp; B: select ename,hiredate,sal from emp; C: select * from emp order deptno; D: select * from where deptno=1
- 查询部门20的员工数量,每个月的工资总和及平均工资( ) A: SELECT sum(nvl(sal,0)),avg(nvl(sal,0)) from emp B: SELECT ename,sum(nvl(sal,0)),avg(nvl(sal,0)) from emp where deptno =20 group by deptno C: SELECT ename,count(empno),sum(nvl(sal,0)),avg(nvl(sal,0)) from emp where deptno =20 group by deptno D: SELECT count(empno),sum(nvl(sal,0)),avg(nvl(sal,0)) from emp where deptno =20 group by deptno
- 以下语句不正确的是( ) A: select * from emp B: select ename,hiredate,sal from emp C: select * from emp order deptno D: select * from where deptno=1 and sal<300
- 查询scott用户的emp表中的总记录数,可以使用下列哪个语句?() A: SELECT MAX(empno) FROM scott.emp; B: SELECT<br/>COUNT(empno) FROM scott.emp; C: SELECT COUNT(comm) FROM scott.emp; D: SELECT COUNT(*) FROM scott.emp;