Thus, to perform positioned update or delete operations, you need to disable the AUTOCOMMIT mode.
因而,要执行定点的更新或删除操作,您必须禁用autocommit模式。
Note: If you're only going to iterate through a cursor, you can leave the AUTOCOMMIT mode enabled.
注:如果仅通过游标进行循环访问,则可以把AUTOCOMMIT模式保留为启用状态。
This is possible because you never executed a COMMIT command, and the AUTOCOMMIT mode was disabled.
这是可能的,因为您永远不执行COMMIT命令,并且禁用了AUTOCOMMIT模式。
Things to note about this method are the use of the default connection and setting the autocommit mode to false.
对于这个方法,需要注意默认连接的使用,还要将自动提交模式设为false。
First, you should turn off autocommit mode so the results of each SQL statement aren't automatically committed to the database.
首先,应当关闭自动提交模式,这样,每条sql语句的结果不会被自动提交给数据库。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
默认情况下,AUTOCOMMIT处于启用状态,并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
默认情况下,AUTOCOMMIT处于启用状态,并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
应用推荐