Click the checkbox to turn it on.
Here’s what the setting does:
| Value | Impact |
| Checked | Autocommit is on. SQL statements that change data will have their changes automatically committed to the database. |
| Unchecked | Default. Autocommit is off. SQL statements that change data will not have their changes automatically committed to the database. A separate COMMIT action is needed. |
What Are The Disadvantages of Autocommit?
Sure, turning on autocommit may save you time and confusion if you expect changes to be saved but they aren’t.
But there are some disadvantages.
You won’t be able to undo any of your changes by issuing a ROLLBACK statement, as you’d normally be able to do. If you run a DELETE or UPDATE statement, your changes are made permanently, and it’s much harder to get them back
It’s not impossible, though. If you have set up save points or database backups then you can restore from a backup, but it is a hassle.
Generally, I would prefer to have this autocommit option turned off in SQL Developer. The only exception would be if you’re running Oracle Express on your own computer and want to save some time with your SQL.
reference: https://www.databasestar.com/sql-developer-autocommit/