Home

Rule description

• WHERE clause conditions should not be contradictory

Non-compliant Code Example

DECLARE 
  firstname NVARCHAR2(75);
  lastname NVARCHAR2(75);
  landmark NVARCHAR2(75);          

BEGIN
	SELECT FIRSTNAME, LASTNAME, LANDMARK 
	INTO firstname,lastname,landmark
	FROM CUSTOMERS
	WHERE (CREDIT_LIMIT = 1800 AND CREDIT_LIMIT = 1100);    --Non compliant code (WHERE clause with the contradictory conditions)
END;

Compliant Code Example

DECLARE 
  firstname NVARCHAR2(75);
  lastname NVARCHAR2(75);
  landmark NVARCHAR2(75);          

BEGIN
	SELECT FIRSTNAME, LASTNAME, LANDMARK 
	INTO firstname,lastname,landmark
	FROM CUSTOMERS
	WHERE CREDIT_LIMIT >= 1100;    --Compliant code (WHERE clause withouts the contradictory conditions)
END;