Home

Types should follow a naming convention

  • Maintainability
  • Minor

Rule description

  • Types should follow a naming convention

 

Non-compliant Code Example 

DECLARE
  TYPE CustNameType_ IS TABLE OF cust.FirstName%TYPE  --Non compliant code (Types is not following the naming convention)
      INDEX BY BINARY_INTEGER;

BEGIN
	NULL;
END;

Compliant Code Example

DECLARE
  TYPE CustNameType IS TABLE OF cust.FirstName%TYPE  --Non compliant code (Types is not following the naming convention)
      INDEX BY BINARY_INTEGER;

BEGIN
	NULL;
END;
Visual Expert 2020
 VEPLSQLRULE119