O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

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

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

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