Code Analysis:
Added the ablity to sort Rule Violations by RuleID.
Create Table |
Load Cols from File:
Load Cols from File can now import column definitions from tables in external databases via ODBC drivers. 32 bit Toad requires 32 bit ODBC drivers. 64 bit Toad requires 64 bit ODBC drivers.
Debugger Exceptions:
Added the ablity to suppress the message when an exception is encountered when debugging while still allowing the break to occur.
Editor:
On the rt-click Refactor menu the following items have been added.
“Convert to ANSI Join Syntax” - Oracle join syntax is converted to ANSI syntax.
“Convert DECODE to CASE” - Uses of the DECODE function are converted into CASE statements.
“Add Column Aliases” - Adds aliases to all columns and expressions in the select list.
“Remove Column Aliases” - Strips aliases from all columns and expressions in the select list.
“Sync GROUP BY and ORDER BY clauses” - Ensures that the ORDER BY clause matches the GROUP BY clause. In other words, all identifiers in the GROUP BY clause are included in the ORDER BY clause and the ordering of identifiers in each matches.
These features act on the statement at caret when there is no selection. When there is a selection then all statements covered by the selection are refactored.
Export Dataset:
Export Dataset can now export to external databases via ODBC drivers. Table must already exist in the target database. 32 bit Toad requires 32 bit ODBC drivers. 64 bit Toad requires 64 bit ODBC drivers.
Generate Schema Script and Schema Compare:
These two windows have a lot of overlapping settings, so you can now rt-click from one to save the settings, and then recall them from either window. These settings do not include connection and output details, just the options. The same feature also exists
between Generate Database Script and Compare Databases.
Import Table Data:
Import Table Data can now import from external databases via ODBC drivers. 32 bit Toad requires 32 bit ODBC drivers. 64 bit Toad requires 64 bit ODBC drivers.
SB-Users-Object Grants:
The “Grants Received” query on this tab is now threaded.
Schema Script Generation and Schema Comparison:
Some optimizations were made in the code that supports schema script generation and schema comparison. The more objects in the schema, the better the speed improvement.
Schema/Database “Def” files:
Schema and database definition files have been renamed to “Snapshot” files. These are available in Generate Schema/Database Script, Compare Schema/Database, and HTML Schema/Database doc generators. When creating these files, there is now an edit box where
you can enter a comment for them. The ellipsis buttons to select the files will now give you a “Snapshot file preview” dialog where you can quickly see key details about each file, making it easy to select the one you want.
Trace File Browser:
When a file containing a deadlock is opened in the Trace File Browser, the statement causing the deadlock will be immediately brought to the attention of the user. A new “Deadlock” tab along the bottom half of the screen will contain all the details provided
in the trace file.