oracle “提交”和“提交工作”有什么区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4099141/
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
What's the difference between "commit" and "commit work"?
提问by Prashanth Reddy
I was asking in terms of the Oracle SQL*PLUS ...
我问的是 Oracle SQL*PLUS ...
回答by David Gelhar
Nothing :-)
没有 ：-）
The WORK keyword is supported for compliance with standard SQL. The statements COMMIT and COMMIT WORK are equivalent.
支持 WORK 关键字以符合标准 SQL。语句 COMMIT 和 COMMIT WORK 是等效的。
回答by Gary Rowe
Nothing - it's an optional statement
没有 - 这是一个可选的声明
To make the changes done in a transaction permanent issue the COMMIT statement.
The syntax of COMMIT Statement is
COMMIT [WORK] [COMMENT ‘your comment'];
WORK is optional.
COMMENT is also optional, specify this if you want to identify this transaction in data dictionary DBA_2PC_PENDING.
要使在事务中完成的更改永久发出 COMMIT 语句。
COMMIT 语句的语法是
COMMIT [WORK] [COMMENT '你的评论'];
工作是可选的。
COMMENT 也是可选的，如果要在数据字典 DBA_2PC_PENDING 中标识此事务，请指定此项。
回答by Bob Jarvis - Reinstate Monica
Five characters - ' WORK'.
五个字符 - 'WORK'。
:-)
:-)
However, the effect of both commands is identical.
但是，这两个命令的效果是相同的。
Share and enjoy.
分享和享受。
