Help
Observation: DELETE Statement with No WHERE Clause
You coded a DELETE statement without a WHERE clause. This statement will delete EVERY row in the referenced table. The example below demonstrates the use of a WHERE clause in a DELETE statement. In this example, only those rows where the column NAME is equal to JOHN DOE will be deleted:
DELETE
FROM
EMP
WHERE
NAME = 'JOHN DOE'
If the WHERE clause was omitted in error, then rewrite the SQL request, and rebind the application plan or package. If the WHERE clause was intentionally omitted, and the referenced table is the target of frequent MASS DELETEs (i.e. no WHERE clause), consider making the tablespace that contains the referenced table SEGMENTED rather than SIMPLE in order to improve processing efficiency.