|"A SAVEPOINT is a marker within a transaction that
allows for a partial rollback. As changes are made in a transaction, we
can create SAVEPOINTs to mark different points within the transaction.
If we encounter an error, we can rollback to a SAVEPOINT or all the way
back to the beginning of the transaction. "
|" Oracle is transaction oriented; that is, it uses
transactions to ensure data integrity. A transaction is a series of one
or more logically related SQL statements you define to accomplish some
task. Oracle treats the series of SQL statements as a unit so that all
the changes brought about by the statements are either committed (made
permanent) or rolled back (undone) at the same time. Savepoints let you
divide long transactions, giving you more control over complex
procedures. For example, if a transaction performs several functions,
you can mark a savepoint before each function. Then, if a function
fails, you can easily restore the Oracle data to its former state,
recover, then re-execute the function. "
|Bron: www.csee.umbc.edu/help/oracle8/server.815/a68022/trans.htm#388 |
|In deze context is SavepoinT een bedrijf waarop u kunt terugvallen zonder dat het voorgaande verloren gaat.|