Toad® for Oracle 16.2
Release Notes
Revised 9/20/2022
New Features and Enhancements |
Enhancements from Idea Pond |
Discontinued Features |
Resolved Issues |
Known Issues |
System Requirements |
Product Licensing |
Getting Started with Toad |
Globalization |
About Us |
Copyright |
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:
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 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.
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.
Toad for Oracle 16.2 is a minor release, with enhanced features and functionality.
Toad for Oracle 16.2 includes component and requirement upgrades. These upgrades address security vulnerabilities previously identified in the third party component.
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
Improved formatting when copy/paste into applications that can accept HTML, e.g., Microsoft Teams, Microsoft Word, etc.
Default fonts have been changed for an updated look. The default UI font is Segoe UI and the default Editor font is Consolas.
Toad Script Runner now supports color schemes.
Improvements to default Editor colors in dark schemes.
Clientless connections now support LDAP.
Unchecking "Save passwords" requires confirmation.
TNSNAMES Editor and LDAP Editor buttons have been moved to more relevant locations.
Improved error handling and recovery when an ORA error is raised during connection initialization.
Improved performance with many apps/actions.
Apps and folders can be cloned using copy/paste.
Connections within the Connection Iterator action can be selectively enabled/disabled.
Tabs for files modified externally have their captions updated to reflect the modification.
A new word list has been added that can be used by you to set your own words to style how you see fit. See the "User List 1" list on the SQL tab (View | Options | Editor | Font and Styling).
A new option has been added to check for locks prior to compiling (View | Options | Execute/Compile).
Execute Snippet chooses better variable names when replacing PL/SQL references with bind variables.
Object set filters are saved as text files.
Filter files can be specified in the respective actions for those windows in the Automation Designer.
The right-click Clone/Copy user window now has a Show SQL button.
Options added to remember the size and position (View | Options | Schema Browser | Describe Dialogs).
Shortcuts have been added for next/previous difference.
Toad debug mode has always been available via Toad.ini settings. Debug mode can now be enabled using controls within the Options window (View | Options | General). Use these options only when requested by Quest Support.
Several improvements to address OWASP Top 10 security risks.
Pause and resume capture for a focused log.
Expanded subobject support
Team Coding status represented by images instead of text
Find dialog options to exclude or limit search to comments and/or strings
Active editor tab is more prominently displayed when using dark themes
Send errors from the Script Output | Errors tab to external editor
An object in the target session matching the selected source object is automatically selected by default.
Save and restore list of connections to execute against
Add ability to clear all output
Window border painting improvements for increased visibility.
Improved speed performance when fetching output.
Grid colors can be customized when a color scheme is applied.
Fields of cursor loop variables, %ROWTYPE variables, and record variables are now shown when variables are included in the list of Code Insight objects. See the Editor | Code Assist page in Options.
A new option allows subobjects to be displayed beneath their parent object in the left-hand side. Click the Browser Style tool button and enable Show LHS Subobjects.
The transactions window was moved from the Output panel to its own dedicated dock panel and will update connection bar button images to indicate when a session is in transaction. Also, transactions will be refreshed when the window is closed if the Always on option is enabled before closing the Transactions panel.
Added ability to load a local or remote files which are not the active alert log.
Include/exclude filters can be set globally for a project.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center