Chapter 5. Manipulating Data

ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Manipulating Data

    • Describe each data manipulation language (DML) statement

    • Insert rows into a table

    • Update rows in a table

    • Delete rows from a table

    • Control transactions

Manipulating Data

In this chapter, I will cover how to manipulate data. In an Oracle Database, this means using SQL data manipulation language (DML) statements. You will also learn how to coordinate multiple changes using transactions. I will discuss how to insert new data into a table, update existing data, and delete existing data from a table.

Because Oracle is a multiuser database and more than ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study 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.

Start your free trial