Database Reference
In-Depth Information
Figure 15.13 shows the result of all changes made using the UPDATE
command, using the following query against the TESTMUSICCD table.
COLUMN ARTIST_NAME FORMAT A20;
COLUMN ARTIST_COUNTRY FORMAT A10;
SELECT ARTIST_NAME, ARTIST_COUNTRY, PRESSED_DATE FROM
TESTMUSICCD;
The rows updated in the table have not yet been saved to the database.
They could be saved using the COMMIT command.
Removing rows using the DELETE command is easier than inserting
and updating rows.
15.5
Deleting Data (DELETE)
The syntax for the DELETE command is as shown in Figure 15.14.
As with the UPDATE command, use the WHERE clause to delete
selected rows from a table, and omit the WHERE clause to delete all the
rows in a table.
Figure 15.14
DELETE
Statement Syntax.
