Oracle Database 10g: A Beginner's Guide

CRITICAL SKILL 2.4

Use Basic update and delete Statements

While select will likely be the command you use the most; you’ll use the update and delete commands regularly, too. As you will in Chapter 6, your programs will have a mixture of DML statements. In this section, we’ll take a closer look at the update and delete commands.

update

It is often necessary to change data stored within a table. This is done using the update command. There are three parts to this command:

1. The word update followed by the table to which you want to apply the change. This part is mandatory.

2. The word set followed by one or more columns in which you want to change the values. This part is also mandatory.

3. A where clause followed by selection criteria. This is ...