Database Reference
In-Depth Information
15
Data Manipulation Language (DML)
In this chapter:
What are DML and transaction control?
How do you use the INSERT command?
How do you update existing rows?
How do you delete one or more rows?
How do you merge two tables together?
This chapter demonstrates the Data Manipulation Language (DML),
showing the syntax and plenty of examples. DML commands are used in
SQL to add, modify, and remove rows of data in database tables. Transac-
tion control using ROLLBACK and COMMIT commands, among others,
plus the MERGE command, are also covered in this chapter.
In previous chapters we have explored a wide variety of methods and
variations of data retrieval. Now, it is time to learn how to make up your
own data!
15.1
What Is DML?
Data Manipulation Language (DML)
is the blanket term for any command
that modifies data in an Oracle database.
The four types of commands that fall under the DML umbrella are as
follows:
INSERT.
Add a new row.
UPDATE.
Modify the data in one or more columns of an existing row.
Search WWH ::




Custom Search