Disabling and Enabling Auto Commit

When executing multiple SQL statements (for example, running a script), auto commit automatically commits work after each statement. If auto commit is disabled, an explicit COMMIT or ROLLBACK statement can be used to control the behavior

1. In your SQL file, enter SET AUTOCOMMIT OFF or SET AUTOCOMMIT ON and then right click and select Execute SQL from the menu. This autocommit setting will be in effect for the life of your connection and will override the default extension setting.

2. To set the default for all SQL files opened with this extension, Press F1 to open the Command Palette and enter Preferences: Open Settings (UI) command.

3. Expand the Extensions node and select Oracle Developer Tools for VS Code Configuration.

4. Check the SQLPlus:Auto Commit checkbox to enable auto commit and uncheck it to disable it.