Home
DELETE and UPDATE statements should contain WHERE clause
Rule description
- DELETE and UPDATE statements should contain WHERE clause
Non-compliant Code Example
PROCEDURE UpdateCustomeCity(customerId in integer, city in nvarchar2(200))
IS
BEGIN
UPDATE CUSTOMERS --Non compliant code (DELETE OR UPDATE statements without WHERE clause)
SET City=city;
END UpdateCustomeCity;
Compliant Code Example
PROCEDURE UpdateCustomeCity(customerId in integer, city in nvarchar2(200))
IS
BEGIN
UPDATE CUSTOMERS --Compliant code (DELETE OR UPDATE statements with WHERE clause)
SET City=city
WHERE Id = customerId;;
END UpdateCustomeCity;