Specifies the rows of the target table or view that will be deleted. If you omit the WHERE clause, SQL deletes all rows of the target table or view. You can specify either a predicate or a cursor name in the WHERE clause.