1、commi、rollback只能用于DML操作,即insert、update、delet;
DML语句,(Data Manipulation Language) 数据操纵语句,即增删改查语句
2、对lock方式加的表锁,不能通过rollback回滚
3、savepoint point1;
update test set prod_id=1;
rollback to point1;
release savepoint point1;
1、commi、rollback只能用于DML操作,即insert、update、delet;
DML语句,(Data Manipulation Language) 数据操纵语句,即增删改查语句
2、对lock方式加的表锁,不能通过rollback回滚
3、savepoint point1;
update test set prod_id=1;
rollback to point1;
release savepoint point1;