Why is this an issue?
Shared coding conventions allow teams to collaborate efficiently. This rule checks that all constant names match a provided regular expression.
Noncompliant code example
With the default regular expression [a-zA-Z]([a-zA-Z0-9_]*[a-zA-Z0-9])?:
DECLARE
constant_ CONSTANT PLS_INTEGER := 42; -- Noncompliant
BEGIN
NULL;
END;
/
Compliant solution
DECLARE
constant CONSTANT PLS_INTEGER := 42; -- Compliant
BEGIN
NULL;
END;
/
