SQL 如何确定 oracle 数据库是否设置为自动提交？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1366851/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How do I find out if an oracle database is set to autocommit?
提问by 0x89
And while we're at it, how do I switch between autocommit and non-autocommit?
当我们这样做时，我如何在自动提交和非自动提交之间切换？
采纳答案by ROMANIA_engineer
Oracle SQL Developer4
Oracle SQL 开发人员4
- Window> Preferences> Database> Advanced> check/uncheck Autocommit
- 窗口>首选项>数据库>高级> 选中/取消选中自动提交
Oracle SQL*Plus
Oracle SQL*Plus
- Use
SET AUTOCOMMIT
SQuirreL SQL ClientVersion 3.7
SQuirreL SQL 客户端3.7 版
- File> New Session Properties> SQLtab > SQL section > check/uncheck Auto Commit SQL
- 文件>新会话属性> SQL选项卡 > SQL 部分 > 选中/取消选中自动提交 SQL
Toad for OracleXpert 9.6.1.1
Toad for OracleXpert 9.6.1.1
- View> Toad Options...> Oracle> Transactions> check/uncheck Commit after every statement
- 查看> Toad 选项...> Oracle>事务> 选中/取消选中在每个语句后提交
SQL Workbench/J
SQL 工作台/J
- Check the "Autocommit" property in the connection profile to set the connection default
- Use SQL > Autocommitfrom the menu to change it dynamically
- Use
SET AUTOCOMMIT
- 检查连接配置文件中的“自动提交”属性以设置连接默认值
- 使用菜单中的SQL > Autocommit动态更改它
- 用
SET AUTOCOMMIT
回答by Vincent Malgrat
There is no such thing as autocommit in Oracle(server). Some clientapplications however default to autocommit (meaning they deliberately issue a commit between each statement). You will have to read the documentation of your application in order to determine if this is the case.
Oracle（服务器）中没有自动提交这样的东西。然而，一些客户端应用程序默认为自动提交（意味着它们故意在每个语句之间发出提交）。您必须阅读应用程序的文档以确定是否属于这种情况。
回答by NidhinSPradeep
Try command show autocommitfrom command prompt. Steps:
show autocommit从命令提示符尝试命令。脚步：
- Open
SQL*PLUSfrom command prompt in admin mode - Type command
show autocommit
SQL*PLUS在管理员模式下从命令提示符打开- 键入命令
show autocommit
