When does Oracle need a commit

After the DML statement (update, INSERT, delete) is written, a manual commit is required, and if there is no commit, the updated content is saved in memory instead of being submitted to the database and will not be seen by the other session (Dialog). Other conversations see the data before the update. Oracle does not automatically commit when the user exits the conversation.

The DDL statement (Create, ALTER, DROP, truncate) comes with a commit, so there is no need to write a commit. Therefore, DDL operations cannot be rolled back.

After executing the DML statement, if the DDL statement is executed again, the uncommitted data will be automatically commit. There are other SQL commands that have the same effect: Audit, Noaudio, comment, Grant, revoke, connect, disconnect, Exit,quit.

If Autocommit is turned on, no manual commits are required after the DML operation. SET autocommit on

When does Oracle need a commit