Removing data with DELETE

Lastly in this section, we examine the use of DML statements to remove data from the database.

The purpose and syntax of the DELETE statement

As important as it is to be able to add and change data, sometimes data needs to be removed from a database. For example, say that a company keeps an opt-in mailing list. When a customer opts-in to receive mailings from the company, their information is placed into a table called mailing_list. If the customer decides that they no longer want to receive information from the company, they can opt-out of the mailings. In such a situation, the information should be removed from the mailing_list table. In SQL, we remove data from a table using the DELETE statement. Its syntax tree is shown ...

Get OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.