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.