Toad World® Forums

Beta Released (12.0.0.32)


#1

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 )