O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required