文件名称：Oracle SQL PLSQL练习题
文件大小：120KB
文件格式：DOC
更新时间：2011-12-02 14:07:04
Oracle SQL PLSQL 练习题 试题
Oracle SQL PLSQL练习60题,简要如下: 1. Oracle发出下列select语句： SQL> select e.empno, e.ename, d.loc 2 from emp e, dept d 3 where e.deptno = d.deptno 4 and substr(e.ename, 1, 1) = ‘S’; 下列哪个语句是Oracle数据库中可用的ANSI兼容等价语句？ A．select empno, ename, loc from emp join dept on emp.deptno = dept.deptno where substr(emp.ename, 1, 1) = ‘S’; B．select empno, ename, loc from emp, dept on emp.deptno = dept.deptno where substr(emp.ename, 1, 1) = ‘S’; C．select empno, ename, loc from emp join dept where emp.deptno = dept.deptno and substr(emp.ename, 1, 1) = ‘S’; D．select empno, ename, loc from emp join dept on emp.deptno = dept.deptno and substr(emp.ename, 1, 1) = ‘S’;