Database Reference
In-Depth Information
Figure 15.15
Three Rows Were
Deleted by Two
DELETE
Commands.
Note:
This is not always strictly true if CASCADE DELETE is used with
constraints. See Chapter 1 for details on Referential Integrity and Chapter
20 for information on constraints.
15.5.3
Deleting All Rows
You can delete all the rows in a table by leaving out the WHERE clause.
The following command will delete all rows in the TESTMUSICCD table:
DELETE FROM TESTMUSICCD;
SQL*Plus Worksheet will reply, “8 rows deleted.”
You could also finally remove the temporarily created table TESTMUS-
ICCD by dropping it.
DROP TABLE TESTMUSICCD;
The final section in this chapter discusses the MERGE command, a new
feature of Oracle Database 9
i
and much improved in Oracle Database 10g.
