1.设置回滚点
SQL>delete from a where id<100;
SQL>savepoint aa;
SQL>delete from a where id<10;
SQL>rollback to aa;
2.设置事务只读
set transaction read only;
SQL>delete from a where id<100;
SQL>savepoint aa;
SQL>delete from a where id<10;
SQL>rollback to aa;
2.设置事务只读
set transaction read only;