同时更新多条记录
SQL> update employees
2 set job = 'SALESREP'
3 , msal = msal - 500
4 , comm = 0
5 , deptno = 30;
10 rows updated.
SQL>
SQL> select * from employees;
EMPNO ENAME INIT JOB MGR BDATE MSAL COMM DEPTNO
---------- -------- ----- -------- ---------- --------- ---------- ---------- ----------
1 Jason N SALESREP 2 18-DEC-65 300 0 30
2 Jerry J SALESREP 3 19-NOV-66 1100 0 30
3 Jord T SALESREP 4 21-OCT-67 1200 0 30
4 Mary J SALESREP 5 22-SEP-68 1300 0 30
5 Joe P SALESREP 6 23-AUG-69 1400 0 30
6 Black R SALESREP 7 24-JUL-70 1500 0 30
7 Red A SALESREP 8 25-JUN-71 1600 0 30
8 White S SALESREP 9 26-MAY-72 1700 0 30
9 Yellow C SALESREP 10 27-APR-73 1800 0 30
10 Pink J SALESREP 28-MAR-74 1900 0 30
下载本文
