PL/SQL Developer sets automatic transaction submission, pldeveloper
Previously, the update table was used on a test machine. There was no commit or PL/SQL Developer.
The next day, I checked the table on my computer and found that the record was not updated.
I want to use the SQL statement to re-update it. It has not been executed for more than 10 minutes.
To manually update the file again, the following message is displayed:
At this point, we found that the table has been locked because update was used on the test machine but not submitted (commit )!!
DML operations such as insert, delete, update, select... for update will trigger the table-Level Lock and row-Level Lock,
After the DML operation, the table is locked before the commit operation, and other transactions cannot operate on the table!
Therefore, after the DML operation, remember to add the statement: commit; or manually Click Commit.
In addition, PL/SQL Developer provides the settings for automatic submission:
A. Automatic commit after the transaction is executed: Tools-> Preferences-> Window Types-> SQL Window: Select "AutoCommit SQL" to enable automatic commit.
B. Log out and submit automatically: Tools> Preferences> Oracle> Connection> Log off with open transaction: Select "Commit ".