天天看点

oracle中的savepoint设置

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;