Manual commit(F10), always neccessary, although confirmation for commit is switched Off

[Peter93]

When I make changes in database, I have always to press F10 to commit the changes.

Under "Preferences->Options" the switch "Confirm Commit & Rollback" is not switched on!!

How can I configure an automatic Commit, when I press F8 for executing the SQL-Command.

PL/SQL Vers. 8 and 10

 

[Marco Kalter]

You can go to Tools > Preferences > SQL Window and enable the "AutoCommit SQL" option (for SQL you explicitly enter in the editor and execute) and the "AutoCommit posted records" option (for records you added/modified/deleted and subsequently posted from the result grid).