background image
<< Using the SAVEPOINT Statement | ROLLBACK to the Savepoint >>
<< Using the SAVEPOINT Statement | ROLLBACK to the Savepoint >>

Creating Savepoints

Controlling Transactions
Querying and Manipulating Data 2-33
Savepoint created.
Manually check the contents of the
regions
table. You may need to click the Refresh
icon. You will see that it now has the updated
region_name
value.
Next, manually check the contents of the
countries
table. You may need to click the
Refresh
icon. You will see that it now has the updated
region_name
values for
'
Zambia
' and '
Nigeria
', but not for '
Zimbabwe
' and '
Egypt
'.