SQL Developer: Commit Vs Transaction Vs Rollback

There are absolutely 3 terms you always need to remember while working with SQL Developer.

A Transaction – is a group of SQL statements that must all be executed together. By default, Oracle adds INSERT, UPDATE and DELETE statements to a transaction

The COMMIT statement commit the changes you have made. In SQL developer the option is F11

The ROLLBACK – it rolls back the changes made by transaction. In SQL developer the option is F12

When you do not COMMIT changes explicitly, when you exit SQL developer, it rollback the changes made to database

There is an Auto commit option in SQL Developer, In Worksheet Parameters node, check the check box “Auto commit SQL Work Sheet”

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.