Toad World® Forums

Beta Released (13.2.0.147)

 

Beta Notes

Formatting/Parsing (QP5)

Formatter

  • Fix: Oracle PL/SQL: Restoring TYPE IS REF CURSOR formatting to old format.

Example:

TYPE t_objects_ref_cursor
IS REF CURSOR RETURN all_objects%ROWTYPE;

becomes

TYPE t_objects_ref_cursor IS REF CURSOR
RETURN all_objects%ROWTYPE;

  • New: Oracle RTRIM function now folds on overflow. This also applies to other functions in other languages having function specific parameter arrangements.

Code Analysis

  • Fix: Fixed false positive in Rule 6728 ("The join operator ( + ) must be used in all conditions related to the joining tables.") when it was used for PL/SQL code.
  • Fix: Rule 6405 ("Avoid defining variables that are not referenced inside the program."): Rewritten to execute around 3 times faster.
  • Fix: Rule 2812 ("Consider defining subtypes for variables with identical datatypes."): Rewritten to execute much faster, e.g. 120 times faster on some large package.