Chat now with support
Chat with Support

Toad for Oracle 14.0 - Release Notes

Release Notes

 

Toad® for Oracle 14.0

Release Notes

Revised 11/9/2020

 

About Toad for Oracle

Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:

  • Understand your database environment through visual representations
  • Meet deadlines easily through automation and smooth workflows
  • Perform essential development and administration tasks from a single tool
  • Deploy high-quality applications that meet user requirements; perform predictably and reliably in production
  • Validate database code to ensure the best-possible performance and adherence to best-practice standards
  • Manage and share projects, templates, scripts, and more with ease

The Toad for Oracle solutions are built for you, by you. Nearly two decades of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over two million, Toad for Oracle continues to be the “de facto” standard tool for database development and administration.

Toad for Oracle resources

Toad World is a unique and valuable resource available to all Toad users. Toad World provides forums, blogs, videos, product information, Beta releases (when available), and Trial downloads for Toad products. Visit Toad World at: https://www.toadworld.com.

Two of the most-often used features of Toad World are the Forums and the Idea Pond.

  • On the Idea Pond page, you can submit your ideas to improve Toad and vote for or comment on other ideas. The Toad team takes your suggestions seriously, and you may even hear back from one of our developers on the topic. We encourage all Toad users—from new to experienced—to let us know how we can improve Toad.
  • On the Forum page, you can ask a question or start a discussion and view all other forums within the Toad community.

The Toad World blog pages feature a broad range of information, including topics of interest to our industry, as well as instructions from team members on how to use the latest Toad features.

The Toad for Oracle web-based training is a perfect accompaniment to your product license. This free training walks you through major product features and explains how to perform frequent tasks. You’ll also see how to utilize time-saving automation functionality. You’ll receive a certificate of completion for each course once you pass the accompanying test.

About this release

Toad for Oracle 14.0 includes component and requirement upgrades. These upgrades address security vulnerabilities previously identified in the third party component.

About Toad® for Oracle® Editions

Each Toad for Oracle Edition is packaged with additional Quest products to expand your experience. The following products may be part of your Toad for Oracle Edition:

The following Toad for Oracle Editions are available:

Edition

Licensed

Toad for Oracle Base Edition

Toad® for Oracle®

Toad for Oracle Professional Edition

Toad® for Oracle® Professional

Toad for Oracle Xpert Edition

Toad® for Oracle® Xpert — Includes all features in Base and Professional Editions

SQL Optimizer for Oracle®

Toad for Oracle Developer Edition

Toad® for Oracle® Xpert

Code Tester for Oracle®

Benchmark Factory® for Databases - Oracle Edition

Toad for Oracle DBA Edition

Toad® for Oracle® Xpert

DB Admin Module Add-on

Spotlight on Oracle® — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle Data Guard

Benchmark Factory® for Databases - Oracle Edition

Toad® Data Modeler

Toad for Oracle DBA RAC Edition

Toad® for Oracle® Xpert

DB Admin Module Add-on

Spotlight on Oracle® with RAC Option — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle Data Guard

Benchmark Factory® for Databases - Oracle Edition

Toad® Data Modeler

Toad for Oracle DBA Exadata Edition

Toad® for Oracle® Xpert

DB Admin Module Add-on

Spotlight on Oracle® with RAC and Exadata Options — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard

Benchmark Factory® for Databases - Oracle Edition

Toad® Data Modeler

Note: The DB Admin Module can be added to any Toad Edition.


For more information about the products in your Toad for Oracle Edition and the minimum system requirements for running these products, see the Toad for Oracle Editions release notes at: https://support.quest.com/technical-documents

New Features and Enhancements

Toad for Oracle 14.0

Subscription Licensing

Note: Applies to Toad for Oracle Subscription with online licensing.

Toad for Oracle Subscription maps licenses to your Quest.com account which are managed via a new, self-service licensing portal. Sign in with your Quest.com account to begin using Toad immediately. New users are automatically issued a 30-day trial during which you are free to explore all of Toad's features. Learn more.

Note: Running multiple copies of Toad is supported, but only the first copy will make presistent changes to configuration files. Additional running instances operate in a "virtual" mode where configuration settings are loaded from your last used options, but changes made do not persist when Toad is closed. This is equivalent to the /VIRTUAL command line switch.

Stability and Security Improvements

Much empasis was placed on improving application stability and security. Well over 100 defects identified by customers, internal testing, and by data collected from the Toad Improvement Program were resolved.

The Toad Improvement Program collects anonymous usage data to help the Toad for Oracle team identify usage patterns and prioritize new development including, but not limited to, organizing the UI to make the features you rely on more accessible. The Toad Improvement Program also collects data on unhandled exceptions so that we can identify and resolve defects. We'd like to thank all who participate in Toad's ongoing success by enabling Toad Improvement Program data collection. To enable Toad Improvement Program data collection, select "Yes" to the participation opt-in in Options (View | Options | Online).

Toolbars and Menus

Database | Create menu

Using data collected from the Toad Improvement Program, the Database | Create menu has been reorganized to group related items and make the commonly used items readibly accessible.

Installer

Quest Update Service

Note: This pertains to Toad for Oracle Subscription, only.

Toad for Oracle Subscription edition is bundled with an update service to periodically check for and deliver product updates. Upon successful installation, the Quest Update Service is configured to run automatically using the LocalService account. Product updates are automatically downloaded and a notification window displays alerting you to the pending updates. You can install or dismiss updates from the notification window.

Note: The Quest Update Service does not provide updates for all products produced by Quest.

Additional Object Type Support

Support for Analytic Views, Attribute Dimensions, In-Memory Join Groups, and Hierarchies has been added to the following areas...

  • Schema Browser
  • Export DDL
  • Compare Schemas
  • Single Object Compare
  • Object Search
  • Create/Alter windows

Editor

SQL Error Dialog

An option has been added to suppress the error dialog shown when running SQL or compiling PL/SQL raises an ORA exception. Errors are still displayed in the Editor's error panel. See the "Display SQL errors in popup dialog" option (View | Options | Editor | Behavior).

Schema Browser

Treeview Display Mode

An option has been added to automatically expand the node for the logon schema when the Schema Browser is opened.

Column Comments

An option has been added allowing for column comments to display as mouse-over tooltips on the Data Grid tab.

Team Coding

General

Azure DevOps Server 2019 is supported.

VCS Login

The VCS login dialog now selects the repository used for the database, by default.

Team Coding Manager

Optimizations resulting in improved load times, especially on large database.

Sensitive Data Protection

Additional rules are included to detect German, French, and Italian sensitive data patterns.

Database Monitor

Anomalies in data used to populate charts can cause auto-scaling such that the remainder of the data is indecipherable. To combat this, a new option has been added allowing for user-defined min/max chart values and how to handle data outside of this range. Data falling outside of the display range can be skipped, replaced with the previous data point's value, or the max/min display value can be used. See the Alerts and Display tab in the Database Monitor Options window.

Single Object Compare

Improved performance in displaying this window.

Database Browser

Pluggable Databases on Oracle RAC

When connected to a container database (CDB) on Oracle RAC you can now specify the pluggable database (PDB) instances to open or close.

Generate Schema Script

Constraints

Constraints are now listed individually in the run report and a new option has been added allowing for constraints to be exported to their own .sql file.

Session Browser

Container Databases

Ability to group and filter by "Container ID" has been added for easily identifying which pluggable database each session pertains to.

Export DDL

Users

Added support for extracting encrypted passwords for the "identified by values" clause using DBMS_METADATA. DBMS_METADATA is accessible to all users having the SELECT ANY ROLE system privilege.

Toad for Oracle 13.3

Table Data

Copy Table Data

When copying table data to another table you can select a subset of source table columns from which to copy. Only data in the selected columns will be copied to the destination table. Copy Table Data is accessible from the Schema Browser Tables view right-click menu (Data | Copy to another schema).

Note: Copy Table Data is also accessible from the Automation Designer (Utilities | Automation Designer).

Import Table Data

Improved detection of field breaks when importing table data from fixed width text files (Database | Import | Import Table Data).

Note: Import Table Data is also accessible from the Automation Designer (Utilities | Automation Designer).

Automation Designer

Export Dataset Action

If the dataset is a SQL file containing multiple SELECT statements, Toad will generate one file per statement. If the destination is Excel File then Toad will generate a new sheet per statement.

Similarly, if the dataset is SQL text then multiple SELECT statements results in multiple files.

File / List Iterator Actions

Support for multiple variable values per line, separated by a delimiter of your choosing. Values are referenced within child actions using the fully qualified variable name which is the action name and the 1-based value index, e.g. %MyFileIterator.1%.

Schema Browser

Tables View, Partitioning Tab

Row Select option added to right-click menu. Row Select is enabled, by default.

Generate Schema Script

Generate Schema Script (Database | Export | Generate Schema Script) has added support for ANALYTIC VIEW, ATTRIBUTE DIMENSION, HIERARCHY, and INMEMORY JOIN GROUP object types.

Toad® Script Runner

The SYSASM, SYSKM, SYSDG, and SYSBACKUP administrative privileges are now supported.

Toad for Oracle 13.2

Unit Testing

This release of 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.

Toad's unit testing feature is built on the utPLSQL open source framework.

  • A new window guides you through the process of defining a test suite containing one or more unit tests. This process creates suite and test stub code which is generated and sent to the Editor.
  • In Editor, you can modify the code, add input values, edit setup and teardown subprograms, and finalize your unit tests.
  • A Unit Test Manager allows you to view, access, and run existing unit tests. Test suites and unit tests are displayed in a tree view. From the Unit Test Manager, you can send tests to the Editor.
  • Test and suite configuration information is stored within the tests and test suites in the form of annotations. The utPLSQL framework uses these annotations to identify and run tests.
  • You can run unit tests from the Editor or from the Unit Test Manager.
  • You can select one or more reports to be generated during the run. Reports fall into one of two categories:

    • Run Results — Reports on test pass/fail status.
    • Code Coverage — Reports on the percentage of tested object code covered (i.e. executed) by your tests.

    Note: Reports are available in many formats suitable for consumption by modern CI/CD and code quality systems.

Connections

Connection Toolbar Buttons

Toad now allows you to rearrange connection bar buttons by drag and drop. Right-click on Toad's toolbar and choose Customize. When the customization dialog is shown you can drag and drop any menu item or toolbutton to reposition it, including the buttons for each active connection.

Database Login Window

In the Database Login window, if you display connections in tabs (e.g., Tabbed by User), you can now filter the tabs. This is useful if you have a large number of connections.

  • To filter the tabs displayed, right-click a tab and select Filter Tabs. Then enter a text string in the search box. The filter persists while the Database Login window is open.

Export Encrypted Connection Passwords

Toad now allows you to include connection passwords when exporting Toad connections. Encryption is applied to protect the passwords. A master password is used to decrypt when importing the connections from the export file.

Filter Connection Tabs

You now can easily filter tabs to display less connections in New Connection. Right-click any connection tab and select Filter Tabs.

Database and Data Management

ASM Flex Disk Groups

The Create Disk Group window now supports Oracle ASM flex disk groups. Create Disk Group is available from the ASM Manager (Database | Administer | ASM Manager).

Note: Flex disk groups are available in Oracle Database 12c Release 2 and newer.

Compare Databases

When comparing single objects (Database | Compare | Single Objects), you now have the option to compare the triggers on the table. To compare triggers, select the Options tab and then select the Include Triggers check box.

When comparing data (Database | Compare | Data), Toad now supports BLOB, CLOB, NCLOB, and XMLTYPE data types. You must have the EXECUTE privilege on the DBMS_CRYPTO package.

Note: The BLOB data type is not supported for synchronization using a sync script. You must use the Compare Data window.

Compare Schemas

Improved handling of mismatched table columns. When a table in the target schema differs from a table in the source schema by name alone, i.e. datatype, scale, precision, and column position are the same, the sync script will default to rename the column. You can override the rename and opt to drop/create the column, instead, when viewing the Difference Details.

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. Review the following details:

  • Each window includes a toolbar for frequently-used actions. Where applicable, buttons are now intuitive icons for easy identification.
  • The tabs have been replaced by a streamlined panel on the left side where applicable categories are listed. Select a category on the left-hand side to display options on the right-hand side.
  • Windows that were modal, such as the Create User window, are now modeless.
  • The format follows enhancements made to other windows in Toad, such as Compare Schemas.

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 Dataset

Use Table Name as Filename

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.

  • To enable this option, right-click within the File field and select Auto filename from table.

  • When this option is disabled, the last export file name is used. The option is disabled by default.
Export to XML as Non-Encoded Data

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

Include Sequences Used by Triggers

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.

  • In the Export DDL dialog (Database | Export | Export DDL), select the Script Options tab and then the Tables tab. After selecting Triggers on the Tables tab, select Sequences used by triggers.

Hybrid Partitioned Tables

Toad supports hybrid partitioned tables in the following areas:

  • Script Generation
  • Create/Alter Table windows
  • Compare Schemas

Note: Hybrid partitioned tables are a new feature of Oracle Database 19c.

Schema Browser

View Objects without Segments

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.

  • In the Schema Browser, when viewing Tablespaces, select the Objects tab and then select Objects without Segments from the drop-down list.
Resetting Sequence Value

When altering a sequence (right-click, Alter) you can reset the sequence back to its start value by checking Reset and clicking OK.

Copy Table Data

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

Expanded Sensitive Data Detection

New rules have been added to extend sensitive data detection to common European Union personal data formats.

Copy Default Policies to Other Rules

You can configure default policies once and apply them to other rules of the same Category or Severity.

Identify Sensitive Data in Grids

When Sensitive Data Awareness is enabled, Toad identifies sensitive data columns in grids used to display table/view data and query results.

Samples of Matched Values

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

Workspace Enhancements

Display the Workspaces toolbar to view the following enhancements:

  • You can now rename the current saved workspace.
  • Workspaces are now sorted alphabetically, by default. You can toggle this feature on or off in Options | Toolbars/Menus | Toolbars.

Migrate Tasks in the Task Scheduler

You can now easily migrate tasks scheduled to run using a previous version of Toad.

  1. Select Utilities | Task Scheduler to open the Task Scheduler.
  2. Tasks that are specified to run using a previous version of Toad are marked in red text. To migrate these tasks to run using your current version of Toad, right-click the task and select Migrate Tasks.

Schema Chooser Enhancement

Right-click on Toad's schema chooser control to view the following enhancement:

  1. From the Users to Load sub-menu you can opt to Hide Oracle-maintained schemas on Oracle Database 12c and newer. Oracle-maintained schemas are internally managed by the database and identified by having a value of 'Y' for the ORACLE_MAINTAINED column in ALL_USERS.

 

Enhancements from Idea Pond

The following is a list of enhancements submitted by Toad for Oracle users through Idea Pond and implemented in this release.

The Toad for Oracle Idea Pond on Toad World is a site where you can submit your ideas to improve Toad and vote or comment on ideas submitted by other users. The Toad development team has always been driven by Toad customers, and Idea Pond makes it easy for you to tell us what changes are most important.

  • To visit Idea Pond, log in to the Toad Forums at: https://forums.toadworld.com. Select the Categories tab. Then click Idea Pond in the Toad for Oracle category.
Enhancement Issue ID Link to Idea Pond
Delete button added to Login window. TMB-1666 link

Discontinued Features

Knowledge Xpert. Knowledge Xpert is no longer available on Toad World. Beginning with release 13.1, Toad components no longer reference the online Knowledge Xpert.

Ask a Question. The Go to Toad World and Ask a Question commands on the Toad World toolbar have been replaced. To ask a question, click the Forums toolbar button to go directly to the forum. To go to Toad World, click the Forums or the Browse Blogs toolbar buttons. You can also use the Help menu: Help | Toad World | Forums. This change is found in Toad for Oracle 13.1 or later.

Integration with Toad Intelligence Central. Beginning with Toad for Oracle 13.1, Toad no longer provides integration with Toad Intelligence Central. The Toad Intelligence Central window is not available and you cannot publish scripts, files, Code Analysis results, and other resources to a Toad Intelligence Central server using Toad for Oracle. You cannot connect to Toad Intelligence Central through Toad for Oracle.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents