Automatic submission of oracle Transaction Processing

Oracle transaction processing automatically submits data in three types: explicit commit, implicit commit, and automatic commit. The three types are described below. 1. explicit submission: Use the COMMIT command to directly complete the submission. The format is:

SQL> COMMIT;

 

2. Implicit commit: The commit that is indirectly completed by using SQL commands is implicit commit. These commands are: ALTER, AUDIT, COMMENT, CONNECT, CREATE, DISCONNECT, DROP, EXIT, GRANT, NOAUDIT, QUIT, REVOKE, RENAME. 3. Automatic submission: If AUTOCOMMIT is set to ON, the system automatically submits the insert, modify, and delete statements after they are executed. The format is:

SQL> SET AUTOCOMMIT ON;

 

Ask how to configure and use the running environment of the console in ora11g? No configuration is required. By default, autocommit is off, but when you use the data definition language DDL (that is, the second implicit commit command), even if autocommit is off, the transaction will be committed. If you want to return to a point before the transaction is committed, you can set savapoint, but rollback to savepoint will be used. When I see the problem in your question, you should use the connect command to switch the user and commit the transaction. In fact, you can log on to the SQL Plus console with another user. Multiple sessions cannot be used in one sqlplus.