About Data Manipulation Language (DML) Statements

Data manipulation language (DML) statements access and manipulate data in existing tables.

In the SQL*Plus environment, you can enter a DML statement after the SQL> prompt.

In the SQL Developer environment, you can enter a DML statement in the SQL Worksheet. Alternatively, you can use the SQL Developer navigation frame and tools to access and manipulate data.

To see the effect of a DML statement in SQL Developer, you might have to click the Refresh icon.

The effect of a DML statement is not permanent until you commit the transaction that includes it. A transaction is a sequence of SQL statements that Oracle Database treats as a unit (it can be a single DML statement). Until a transaction is committed, it can be rolled back (undone). For more information about transactions, see "About Transaction Control Statements".

This section contains:

• About the INSERT Statement

• About the UPDATE Statement

• About the DELETE Statement