Таблиця EXAMPLE

id INTEGER

1

2

3

4

5

6

7

8

9

10

11

dat INTEGER

100

110

120

130

140

150

160

170

180

190

200

Крок

Транзакція T1

1

UPDATE example SET dat=101 WHERE id=1;

2

SAVEPOINT Point1;

3

UPDATE example SET dat=102 WHERE id=1;

4

SAVEPOINT Point2;

5

UPDATE example SET dat=103 WHERE id=1;

6

ROLLBACK

TO

SAVEPOINT

UPDATE example SET dat=104 WHERE dat=102;

7

ROLLBACK

TO SAVEPOINT

8

COMMIT;