---
title: "SQL Developer: Commit Vs Transaction Vs Rollback"
description: "The COMMIT, ROLLBACK and Transaction are very important in terms of SQL. When you are a Oracle SQL developer you need to work with SQL developer always. Read more."
url: https://srinimf.com/2017/04/04/3-best-sqldeveloper-terms-that-always-you-need-handy/
date: 2017-04-04
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2017/04/pexels-photo-7092574.jpeg?fit=1880%2C1253&ssl=1
categories: ["Oracle"]
tags: ["Oracle tips and tricks"]
type: post
lang: en
---

# SQL Developer: Commit Vs Transaction Vs Rollback

There are absolutely 3 terms [you always need](https://srinimf.com/2018/04/05/top-sas-statements-list/) to remember while working with SQL Developer.

Related[6 JCL Job-card Parameters to Remember Always](https://srinimf.com/2016/12/25/the-jcl-best-6-keywords-you-need-to-remember-always/)

**A Transaction –** is a group of SQL statements that must all be executed together. By default, Oracle adds INSERT, [UPDATE and DELETE](https://srinimf.com/2016/01/25/db2-in-cursor-with-multi-record-fetching/) 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

Related[How SYNCPOINT Performs to Carry out LUW in CICS](https://srinimf.com/2015/11/11/confusing-cics-commands-syncpoint-and-syncpoint-rollback/)

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

Related Posts

- [COMMIT Vs ROLLBACK top differences to manage data](https://srinimf.com/2014/08/25/sql-commit-keeps-dba-away/)DateAugust 25, 2014
- [Understand Flashback Table in Oracle to Recover Deleted Data](https://srinimf.com/2022/02/26/how-to-recover-deleted-data-in-oracle/)DateFebruary 26, 2022
- [How to Avoid SQL deadlock: 4 Precise Ways](https://srinimf.com/2017/10/27/sql-deadlock-four-precise-ways-to-avoid-it/)DateOctober 27, 2017

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2017%2F04%2F04%2F3-best-sqldeveloper-terms-that-always-you-need-handy%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2017%2F04%2Fpexels-photo-7092574.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=SQL%20Developer%3A%20Commit%20Vs%20Transaction%20Vs%20Rollback)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2017/04/04/3-best-sqldeveloper-terms-that-always-you-need-handy/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2017/04/04/3-best-sqldeveloper-terms-that-always-you-need-handy/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2017/04/04/3-best-sqldeveloper-terms-that-always-you-need-handy/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2017/04/04/3-best-sqldeveloper-terms-that-always-you-need-handy/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20SQL%20Developer%3A%20Commit%20Vs%20Transaction%20Vs%20Rollback&body=https%3A%2F%2Fsrinimf.com%2F2017%2F04%2F04%2F3-best-sqldeveloper-terms-that-always-you-need-handy%2F&share=email)
-

### Like this:

Like Loading…