Recently, I have to deal with transactions. I have sorted out the following common Oracle transaction methods:
CommitUsage :(The transaction is completed, the data is modified successfully, and is open to other users.)
For example:
Update Plan type Set Plan type = ' Haha ' Where Plan type = ' Test ' ;
Commit ;
After the update statement is executed, the data in the table will not be changed.CommitThen the data in the table can be modified.
RollbackUsage :(Undo transactions, undo all operations)
Update Plan type Set Plan type = ' Haha ' Where Plan type = ' Test ' ;
Rollback ;
The updated data will be rolled back directly.
Rollback to savepointUsage :(Undo the operation after the set rollback point)
Update Plan type Set Plan type = ' Haha ' Where Plan type = ' Test ' ;
Savepoint my_savepoint;
Update Plan type Set Plan type = ' Test 2 ' Where Plan type = ' Work ' ;
Rollback To My_savepoint;
The data before the rollback point will actually affect the table, and the data after the rollback point will be rolled back.