O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

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

7.1. Manipulating Data through SQL

The Structured Query Language, SQL for short, includes Data Definition Language (DDL) statements, Data Control Language (DCL) statements, and Data Manipulation Language (DML) statements. You learned how to create, alter, and delete objects using DDL statements in Chapter 3, "Database Storage and Schema Objects." Chapter 6, "User Administration and Security," showed you how to use the DCL statements GRANT and REVOKE to give and take privileges on database objects. In this section, you will learn how to use the DML statements INSERT, UPDATE, and DELETE to add, modify, and remove data from your tables.

After using DML statements to add rows to a table, update rows in a table, or delete rows from a table, you must ...

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