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

image 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 ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.