A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.
Open a connection:
Begin a transaction:
Set a savepoint:
Insert more data:
Roll back to the savepoint:
Commit the transaction:
The table only contains data inserted up to the savepoint: