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);