Beta Notes
Rebuild Table
Rebuild Table now looks nicer.��
Generate Database Script
Generate Database Script now looks nicer, with a similar look and feel to Compare Schemas, Generate Schema Script, and Compare Databases.
�
�
Formatting/Parsing (QP5)
Parser
-
Fix (QP 2766) : Packages: Chunking fixed when the keyword AS is used in a CAST function.
-
New (QP 2755) : Support for SET SQLFORMAT.
-
New (QP 2758) : Support for custom analytic functions in PIVOT clause.
-
New (QP 2755) : Several small fixes and (undocumented) additions in JSON_QUERY, JSON_VALUE, JSON_TABLE and ALTER SESSION.
Formatter -
New (QP 138) : Formatter now uses less memory during formatting large lumps of SQL text.
-
Fix (QP 2768) : Formatter fails to align values in VALUE clause.
Code Analysis -
New (QP 2285) : Rule 6709 (“ROWNUM found in a WHERE clause.”)
-
New (QP 2783) : Rule 2141 (“Make sure the given Schema Prefix name exists for all objects.”)
-
New (QP 2783) : Rule 2142 (“Table names should be under N characters.”)
-
New (QP 2783) : Rule 2143 (“When creating an index or a table then specific tablespaces should be used.”)
-
New (QP 2783) : Rule 2144 (“When creating a table then a primary key should be created.”)
-
New (QP 2783) : Rule 2145 (“Avoid using the listed data types.”)
-
Fix (QP 2735) : Rule 2746 (“A CASE statement should have an ELSE clause”) Rule type, category and severity were missing, causing the rule not to appear in the Toad rule universe.
-
Fix (QP 2735) : Rule 6748 (“Consider writing IF THEN CONTINUE as CONTINUE WHEN.”) Rule type, category and severity were missing, causing the rule not to appear in the Toad rule universe.