SET TRANSACTION ISOLATION LEVEL READ COMMITTED |
SET TRANSACTION READ ONLY |
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE |
SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment_1 |
COMMIT |
SAVEPOINT spname |
每个事务只能回退一次,如果只退回到保留点,则保留点前面的被提交。
ROLLBACK |
ROLLBACK TO spname |