更新—修改Oracle基础教程

更新—修改t用于更新数据表中的数据UPDATE table_name SET column_name = new_value[,…] WHERE condition; t更新DEPT表，将20号部门名称修改为'销售部'，地址修改为'北京' UPDATE DEPT SET DNAME = '销售部', LOC = '北京' WHERE DEPTNO = 20; t子查询也可在UPDATE中使用，将职工领导是KING的人员薪资增加100元UPDATE SCOTT.EMP SET SAL = SAL + 100 WHERE EMPNO IN (SELECT E.EMPNO FROM SCOTT.EMP E, SCOTT.EMP G WHERE E.MGR = G.EMPNO AND G.ENAME = 'KING'); UPDATE SCOTT.EMP SET SAL = SAL + 100 WHERE EXISTS (SELECT * FROM SCOTT.EMP E, SCOTT.EMP G WHERE E.MGR = G.EMPNO AND E.EMPNO = EMP.EMPNO AND G.ENAME = 'KING'); DDL数据操作语言