There are two embedded versions of the DELETE statement: one deletes rows according to the search criteria specified in its WHERE clause, and the second deletes the row to which the specified cursor is positioned.