The Oracle DELETE statement removes one or more records from a table.

A subset may be defined for deletion using a condition WHERE, otherwise all records are removed.

A DELETE statement does not return any rows.

The general format is:

DELETE FROM tablename [WHERE condition]

Example 1:

DELETE FROM country WHERE countrycode=34;

Example 2:

DELETE FROM country;
--DANGER! remove all records

Example 3:

DELETE FROM country WHERE countrycode in (12,20,34);