Using Oracle DML
DML is short for "data Manipulation
Language: and DML changes data in a table.
If you insert a row into a table, that is
DML. Oracle DML is a sub-set of the ANSI SQL
standard and DML verbs include insert,
update, delete and merge.
See
DML updates,
DML delete
When you create,
change or remove a database object, it is
referred to as data definition language
(DDL). All DML statements change data and
must be committed before the change becomes
permanent.
Also see my notes on
Oracle parallel DML
The table is the
basic building block of any database system
and DML is the tool to populate and manage
the data within the table. You create
a table by defining the column names and
their data types.
Each parallel execution server creates a
different parallel process transaction. As a
result, parallel DML requires more than one
rollback segment for performance.
However, there are some restrictions as
shown below:
- A
transaction can contain multiple
parallel Oracle DML statements that
modify different tables, but after
parallel DML statements modify a table,
no subsequent serial or parallel
statement (DML or query) can access the
same table again in that transaction.
-
Parallel DML operations cannot be done
on tables with triggers. Relevant
triggers must be disabled in order to
parallel DML on the table.
- A
transaction involved in a parallel DML
operation cannot be or become a
distributed transaction.
-
Clustered tables are not supported.
old_values - These are the old column
values related to the change. These are the
column values for the row before the DML
change. If the type of the DML statement is
UPDATE or DELETE, these old values include
some or all of the columns in the changed
row before the DML statement. If the type of
the DML statement is INSERT, there are no
old values.
new_values - These are the new column
values related to the change. These are the
column values for the row after the Oracle
DML change. If the type of the Oracle DML
statements is UPDATE or INSERT, these new
values include some or all of the columns in
the changed row after the DML statements. If
the type of the Oracle DML statements is
DELETE, there are no new values.
|
|