7/10/2023 0 Comments Manual avg updateYou use the COMMIT, ROLLBACK, SAVEPOINT, and SET TRANSACTION commands to control transactions. If your program fails in the middle of a transaction, Oracle detects the error and rolls back the transaction, restoring the database to its former state. ![]() ![]() It is important not to allow one operation to succeed while the other fails.Īt the end of a transaction that makes database changes, Oracle makes all the changes permanent or undoes them all. For example, two UPDATE statements might credit one bank account and debit another. A transaction is a series of SQL data manipulation statements that does a logical unit of work. ![]() Oracle is transaction oriented that is, Oracle uses transactions to ensure data integrity.
0 Comments
Leave a Reply. |