oracle - 什么语句需要承诺？ [英] oracle - what statements need to be committed?

问题描述

为了避免锁，需要在表上进一步操作之前需要提交的语句列表是什么？我不是说多个语句和事务完整性的完整事务（而是我指的是单个语句）。

What are the list of statements that need to be committed before further action on the table in order to avoid a lock? I am not talking about full transactions with multiple statements and transaction integrity (instead I am referring to single statements).

我知道insert应该被提交，但truncate有一个自动提交。

I know insert should be committed but truncate has an autocommit. What is the full list of statements that need to be committed?

需要提交（起始名单）：

Need to be committed (starter list):

UPDATE
INSERT
DELETE

推荐答案

DML（数据操作语言）命令需要< a>提交/回滚。 这里是这些命令的列表。

DML (Data Manipulation Language) commands need to be commited/rolled back. Here is a list of those commands.

数据操作语言（DML）语句用于在模式对象中管理数据
。一些示例：

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table, the space for the records remain
MERGE - UPSERT operation (insert or update)
CALL - call a PL/SQL or Java subprogram
EXPLAIN PLAN - explain access path to data
LOCK TABLE - control concurrency

这篇关于oracle - 什么语句需要承诺？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！