Code Analysis Rules:
-
Fix: Rule 6413 ( Avoid using quoted identifiers for variable names ) : This rule has been made more selective to flag declarations only.
-
New: Rule 2511 ( Never handle unnamed exceptions using the error number )
-
New: Rule 2512 ( Always use a string variable to execute dynamic SQL )
-
New: Rule 2748 ( Avoid using CONTINUE in a loop )
-
New: Rule 2749 ( A CURSOR FOR loop retrieving just one row is better written as a SELECT )
-
New: Rule 2750 ( List columns explicitly in your INSERT statement )
-
New: Rule 2751 ( Do not EXECUTE IMMEDIATE a literal, use bind variable instead )
-
New: Rule 2752 ( Use named parameter notation )
The following new rules in the 29xx range are refactoring rules where any hits should be repaired and then these rules should be rerun until no more hits show up. -
New: Rule 2901 ( Simplify Numeric Expressions )
-
New: Rule 2902 ( Rebalance Numeric Expressions )
-
New: Rule 2903 ( Simplify Character Expressions )
-
New: Rule 2904 ( Rebalance Character Expressions )
-
New: Rule 2905 ( Replace Substring Operations )
-
New: Rule 2906 ( Fix Non-ANSI Syntax JOIN Mistakes )
-
New: Rule 2908 ( Simply Excessive OR’s as an IN Clause )
-
New: Rule 2909 ( Simplify NOT Clauses (DeMorgan’s Theorem) )
-
New: Rule 2910 ( Combine similar sub-queries with “and” )
-
New: Rule 2911 ( Replace “decode” function with CASE construct )