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

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide 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.