O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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

Images

3

Manipulating Data

CERTIFICATION OBJECTIVES

3.01     Truncate Data

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. We’ll get some perspective by looking at DML with regard to where it fits into the larger context of SQL. Then we will review DML statements and their usage and look at some specific examples. Finally we will review some supplemental statements that are used to control transactions involving DML.

CERTIFICATION OBJECTIVE ...

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