delete works for both single-row and multiple-row operations.
A simplified version of delete syntax is:
delete table_name where column_name = expression
Here is the complete syntax statement, which shows that you can remove rows either on the basis of specified expressions or based on data from other tables:
delete [from]
[[database.]owner.]{view_name | table_name}
[where search_conditions]
delete [[database.]owner.] {table_name | view_name}
[from [[database.]owner.]{view_name | table_name
[(index {index_name | table_name }
[prefetch size ] [ lru | mru])]}
[, [[database.]owner.] {view_name | table_name
(index {index_name | table_name }
[prefetch size ] [lru | mru])]}]...]
[where search_conditions]
delete [from]
[[database.]owner.] {table_name | view_name}
where current of cursor_name
The where clause specifies which rows are to be removed. When no where clause is given in the delete statement, all rows in the table are removed.
