OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

3Manipulating Data

CERTIFICATION OBJECTIVES

3.01 Describe Each Data Manipulation Language (DML) Statement

3.02 Insert Rows into a Table

3.03 Update Rows in a Table

3.04 Delete Rows from a Table

3.05 Control Transactions

Two-Minute Drill

Q&A Self Test

This chapter begins to look at that part of SQL known as Data Manipulation Language, or DML. We’ll get some perspective by looking at DML and where it fits into the larger context of SQL as a whole. Then we’ll review DML statements and look at some specific examples and usages of DML statements, and review some supplemental statements that are used to control transactions involving DML.

CERTIFICATION ...