1 update
语法:
update + 表名+set + 更改内容 +过滤条件.
例如:
update emp2 set sal=sal*2,ename= ename||'-' where deptno = 10
2 delete
delete from emp2;
emp2 全删;
delete from emp2 where ....
过滤条件.
1 update
语法:
update + 表名+set + 更改内容 +过滤条件.
例如:
update emp2 set sal=sal*2,ename= ename||'-' where deptno = 10
2 delete
delete from emp2;
emp2 全删;
delete from emp2 where ....
过滤条件.