Toad World® Forums

Beta Released (13.0.0.30)

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.