3/29/2024 0 Comments Cursors in plsqlCOMMIT makes permanent any database changes made during the current transaction. You 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |