OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition

CERTIFICATION OBJECTIVES

10.01   Describe Each Data Manipulation Language (DML) Statement

10.02   Insert Rows into a Table

10.03   Update Rows in a Table

10.04   Delete Rows from a Table

10.05   Control Transactions

         Two-Minute Drill

Q&A   Self Test

This chapter is all about the commands that change data. Syntactically, the DML commands are much simpler than the SELECT command that has been studied so far. However, there is a large amount of relational database theory that comes along with DML. As well as understanding the commands that ...