oracleupdate的使用方法

同时更新多条记录

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

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com