比如 我得except(pl/sql有该关键字)老是用不上 intersect minus 都不能用allexample
select Exp_Code from exp_dict intersect select Exp_Code from exp_dict 对的intersect换except 错 intersect带all错还有些标准oracle语法也报错(我是 10g)
select Exp_Code from exp_dict intersect select Exp_Code from exp_dict 对的intersect换except 错 intersect带all错还有些标准oracle语法也报错(我是 10g)
2 minus
3 select * from emp where sal<2000;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
7566 JONES MANAGER 7839 1981-04-02 2975 20
7698 BLAKE MANAGER 7839 1981-05-01 2850 30
7782 CLARK MANAGER 7839 1981-06-09 2450 10
7788 SCOTT ANALYST 7566 1987-04-19 3100 20
7902 FORD ANALYST 7566 1981-12-03 3000 20
SQL> select * from emp where sal<3000
2 intersect
3 select * from emp where sal>2000;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
7566 JONES MANAGER 7839 1981-04-02 2975 20
7698 BLAKE MANAGER 7839 1981-05-01 2850 30
7782 CLARK MANAGER 7839 1981-06-09 2450 10
SQL> select * from emp where sal>all(
2 select sal from emp where deptno=30)
3 /
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7566 JONES MANAGER 7839 1981-04-02 2975.00 20
7788 SCOTT ANALYST 7566 1987-04-19 3100.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7902 FORD ANALYST 7566 1981-12-03 3000.00 20
SQL>