1.操作运算符:
+ - * / mod(a,b)
SQL> select sal, sal+1, sal-1, sal*2 ,sal/2,mod(sal,2) from emp;
SAL SAL+1 SAL-1 SAL*2 SAL/2 MOD(SAL,2)
---------- ---------- ---------- ---------- ---------- ----------
800 801 799 1600 400 0
1600 1601 1599 3200 800 0
1250 1251 1249 2500 625 0
2975 2976 2974 5950 1487.5 1
1250 1251 1249 2500 625 0
2850 2851 2849 5700 1425 0
2450 2451 2449 4900 1225 0
3000 3001 2999 6000 1500 0
5000 5001 4999 10000 2500 0
1500 1501 1499 3000 750 0
1100 1101 1099 2200 550 0
2.关系运算符:
> >= < <= = !=或<>
判断是否为null,必须是is,或is not
3.赋值:
update xxx set ename = ''
plsql :=
4.逻辑运算符:
or and not
SQL> select empno from emp where mgr=7788 and job='CLERK';
EMPNO
----------
7876