Toad World® Forums

Beta Released (12.11.0.31)

Beta Notes

Code Analysis Rule 2131

Rule 2131 (“Use CONSTANT keyword wherever possible.”) improved.

Code Analysis Rule 2612

Rule 2612 (“If you have an expression an alias should be used”) improved.

Code Analysis Rule 2757

Rule 2757 (“A CASE expression should have an ELSE clause to avoid it returning NULL”) was missing some values causing the rule not to show up in Toad.

Code Analysis Rule 3010

Rule 3010 (“Avoid redefining Oracle’s predefined exceptions.”) was formerly named “Avoid naming exceptions the same as Oracle’s predefined exceptions.”

Code Analysis Rule 5406

Rule 5406 (“Remove unused parameters or modify code to use the parameter.”) now handles external functions.

Code Analysis Rule 6406

Rule 6406 (“Avoid multiple definitions of the same element in nested scopes.”) improved.

Compare Table Data

Made some significant performance improvements in comparison speed, when comparing tables in different connections that have a primary or unique key constraint.

Oracle 12c R2 Support

Support for the following new Oracle 12c R2 syntax, including Formatting:

  • CREATE + ALTER TABLE

  • CREATE + ALTER [PLUGGABLE] DATABASE

  • CREATE + ALTER MATERIALIZED VIEW

  • New forms of Queries

PLDoc Support

A wizard to run PLDoc has been added under Database -> Report. PLDoc is an open source project that creates HTML documentation of your PL/SQL objects using special comment tags (similar to JavaDoc), and information from the data dictionary. More info about PLDoc can be found here: http://pldoc.sourceforge.net/maven-site/

RETURNING clause

A RETURNING clause with an alias will now generate a syntax error.