From the course: Oracle Database 19c: Advanced SQL

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Using COMMIT

Using COMMIT - Oracle Database Tutorial

From the course: Oracle Database 19c: Advanced SQL

Start my 1-month free trial

Using COMMIT

“

- [Instructor] The Oracle database commit statement is straight forward. Making database changes permanent but it has a few options you might need on occasion. A commit makes one or more changes in transaction permanent. Until a commit is issued, other sessions will not see the changes made in the current session. Let's find out how commit fits in with the other DML and transaction control statements. A commit is one of several transaction control statements available. The list is somewhat short. Commit saves any pending transactions from data manipulation language DML statements to permanent storage. Rollback takes time any pending transactions since the last commit and discards them. You and other users won't see them in the table. If your transaction is complex, you might use safe point to allow partial rollback of a transaction and how far to roll it back before any commit is done. Set transaction can make a transaction either read only or read write which is useful when other…

Contents