关于COMMIT的问题？？

Toms_zhang

有２种方法：

第一： 设置事务为自动提交方式

SQL> show autocommit
autocommit OFF
SQL> set autocommit on;

SQL>delete from table_name where ...

即可自动提交

第二：设置自治事务

　　　 pragma autonomous_transaction;
　　　    ......　　
　　　  commit|rollback;
　　　
　　　用法：可将以上语句放在一个trigger里，针对Ａ表做
DML操作，可对Ｂ表中的数据进行操作，并实现自动提交．
而不管Ａ表上的操作是否commit；

不知道各位还有什么高见，请一起讨论．

wyq21973

依赖你所使用的前端工具，在SQL*PLUS中的设置命令是SET AUTO[COMMIT]{ON|OFF|IMM[EDIATE]|n}

xzh2001

set autocommit on

lxwin2008

请问自动提交的时机是什么时候呢？

qhuang

THANKS

wyq21973

最初由 lxwin2008 发布
[B]请问自动提交的时机是什么时候呢？ [/B]

Controls when Oracle commits pending changes to the database. ON commits pending changes to the database after Oracle executes each successful INSERT, UPDATE, or DELETE command or PL/SQL block. OFF suppresses automatic committing so that you must commit changes manually (for example, with the SQL command COMMIT). IMMEDIATE functions in the same manner as the ON option. n commits pending changes to the database after Oracle executes n successful SQL INSERT, UPDATE, or DELETE commands or PL/SQL blocks. n cannot be less than zero or greater than 2,000,000,000. The statement counter is reset to zero after successful completion of n INSERT, UPDATE or DELETE commands or PL/SQL blocks, a commit, a rollback, or a SET AUTOCOMMIT command.

--------------------------------------------------------------------------------
Note:
For this feature, a PL/SQL block is considered one transaction, regardless of the actual number of SQL commands contained within it.  
--------------------------------------------------------------------------------

yorking

Delphi/BCB通过DBE操作的默认是AutoCommit的