插入 insert into

insert into um_user values('10001','tom','男'，'上海');insert into um_user(usercode,username) values('10001','tom');insert into um_user                 select *from user;

删除 delete

delete from um_user;--删除表中所有数据delete from um_user where usercode='10001';--删除表中符合条件的数据

###更新 update

update um_user set name='lilei' ;--更新表中所有数据update um_user set name='lilei' where usercode='10001';--更新表中符合条件的数据

无条件多表插入

insert allinto user1 values(usercode,username,sex,place)into user2 values(usercode,username,sex,place)select *from um_user;

有条件多表插入

insert first:同一个符合插入第一个，其余不插入，insert all:符合就插入

insert firstwhen sex='男' then into user1 values(usercode,username,sex,place)when sex='女' then into user2 values(usercode,username,sex,place)select *from um_user;

子查询更新

update um_user set sal=(select avg(sal)from um_user);

事物操作

1. commit;
2. rollback;
3. savepoint name;
4. rollback to [savepoint] name;