Toad for Oracle 13.2
Unit Testing
Toad for Oracle includes a new feature that allows you to easily create unit tests to test your PL/SQL code. Testing PL/SQL objects, such as packages and procedures, is an integral part of the agile development process and helps ensure that your code functions as designed.
Create Object Window Enhancements
This release includes an enhanced Create (Alter) Object window. New layout and appearance make this window easier to use while functionality remains unchanged.
DBMS Auto Index
Support for Oracle's DBMS_AUTO_INDEX package has been added. This feature allows Oracle to automatically create indexes as needed to achieve optimal performance by analyzing user queries.
Note: DBMS_AUTO_INDEX is available on Oracle Database 19c, Enterprise Edition on Engineered Systems and Exadata Cloud Service, only.
Export Data Set
When you export data from a data grid, the Export Dataset dialog allows you to enter a name for the export file. You can now specify whether or not to automatically create a file name based on the name of a table in the query.
Now when exporting data to XML, if you select an encoding method other than ANSI, certain data is not encoded. Specifically, all the characters listed in “Non-restricted characters” in Valid characters in XML will be exported as clear text instead of using the "&#nnnn;" encoding format.
Export DDL
When exporting DDL for a table, if you select to include triggers, you now have the option to include the sequences used by the triggers.
Toad supports hybrid partitioned tables in the following areas:
Note: Hybrid partitioned tables are a new feature of Oracle Database 19c.
Schema Browser
When viewing Tablespaces in the Schema Browser, the Objects tab now includes a new option to view objects that do not have segments. Because Oracle does not always create a segment for a new object until a row is added, these objects do not display in the Segments list. This new option allows you to display a list of objects without segments.
When altering a sequence (right-click, Alter) you can reset the sequence back to its start value by checking Reset and clicking OK.
XMLTYPE is now supported when copying data from one table to another. Copy Table Data is accessible from the Schema Browser's right-click menu, Data | Copy to another schema, and as an action in the Automation Designer.
Sensitive Data Awareness and Protection
New rules have been added to extend sensitive data detection to common European Union personal data formats.
You can configure default policies once and apply them to other rules of the same Category or Severity.
When Sensitive Data Awareness is enabled, Toad identifies sensitive data columns in grids used to display table/view data and query results.
When viewing rules (View | Toad Options | Sensitive Data | Search Rules) all built-in rules ( RuleID < 4000) display a list of sample values the rule will match.
Automation Designer
Analyze Objects Action
Updated GUI is easier to use and still fully featured.
General
Display the Workspaces toolbar to view the following enhancements:
You can now easily migrate tasks scheduled to run using a previous version of Toad.
© ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center