Home

DML events clauses should not include multiple OF clauses

Rule description

  • DML events clauses should not include multiple OF clauses

 

Non-compliant Code Example

CREATE TRIGGER trgCustomerAdded 
FOR INSERT OF FIRSTNAME OR INSERT OF LASTNAME       --Non compliant code (DML events having multiple OF clauses)
ON CUSTOMERS

BEGIN
:new.minimunExpense:= 1800;

END trgCustomerAdded;
Visual Expert 2020
 VEPLSQLRULE54