Oracle supports an "AUTOCOMMIT" option in its database product where each individual SQL statement is treated as a transaction and is automatically committed right after it is executed. As a user, you have the option to turn this option on or off based on your preference. When AUTOCOMMIT is turned off, you can allow two or more statements to be grouped into one single transaction. You may require administrative rights on certain computer to complete this task.
- Skill level:
Other People Are Reading
Launch your preferred terminal window based on your operating system. If you use Windows, click the Start menu, and type "cmd" in the search box and press "Enter" key. This will launch Command Prompt. If you use Linux, access the terminal window from the "Application" menu on the top bar by either choosing "System Tools" or "Utilities."
Type the following command:
SET AUTOCOMMIT OFF
Press "Enter" key to turn off AUTOCOMMIT.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for