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 ...
Get OCA: Oracle 10g™ Administration I: 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.
