Home

Variables and columns should not be self-assigned

Rule description

  • Variables and columns should not be self-assigned

 

Non-compliant Code Example

UPDATE CUSTOMERS
		SET City=City           --Non compliant code (Self assigned column)
		WHERE Id = customerId

Compliant Code Example

UPDATE CUSTOMERS
		SET City=p_city         --Compliant code
		WHERE Id = customerId
Visual Expert 2020
 VEPLSQLRULE63