Toad® for Oracle® 13.0
|New Features and Enhancements|
|Enhancements from Idea Pond|
|Getting Started with Toad|
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.
The parent site for all Toad family products is ToadWorld.com, where you will find videos, white papers, web-based training, expert blogs and podcasts, as well as beta releases, trial downloads and much more. The Toad for Oracle Community on this site focuses this content specifically on Toad for Oracle.
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 13.0 is a minor release, with enhanced features and functionality.
All commercial versions of Toad for Oracle are bundled with additional Quest products, based upon the license that you purchased. These bundles are known as Editions and include the following:
Toad for Oracle Base Edition
Toad for Oracle Professional Edition
Toad for Oracle Xpert Edition
Toad for Oracle Developer Edition
Toad for Oracle DBA Edition
Toad for Oracle DBA RAC Edition
Toad for Oracle DBA Exadata 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 2018 Editions release notes at:
Dual Monitor Support has been added. You can now use Toad in either its standard MDI (Multiple Document Interface) mode or in SDI (Single Document Interface) mode.
Alternatively, you can use SDI mode, where every window opens in its own window, outside the Toad application. This mode provides complete control over where windows are placed. As a result, not only can you move individual windows to other monitors, but you can also dock windows, such as the Project Manager, Team Coding Manager, and Object Palette. You can spread your work out across multiple monitors to work on multiple tasks simultaneously without having to wait for certain processes to finish. When processes are running in background threads, they can be kept visible, rather hidden behind other windows, so you know immediately when they are finished.
Note: Connection border colors cannot be drawn around forms operating in either SDI or "popped-out" mode; however, the colored status bar will still be shown.
The Trace File Browser has the following changes:
The Compare Individual Objects feature has been improved:
The Compare Data feature has been improved:
Team Coding VCS debugging has been improved:
Support was added for setting the encoding option at an action level:
When connection colors are used, Toad combo boxes that display a list of connections now include the colors for each connection shown. These include:
In a stacked named parameter list, whenever a parameter with a large values wraps its value to a next line, it will no longer trigger all other parameters to do so. In addition, text folds better on low right margins. Example:
p_partno => r.partno, p_synonym_of => r.synonym_of, p_value_lines => COALESCE (r.value_lines, 0) + COALESCE (r.repl_value_lines, 0), Former output (5.307): p_partno => r.partno, p_synonym_of => r.synonym_of, p_value_lines => COALESCE (r.value_lines, 0) + COALESCE (r.repl_value_lines, 0), New output: p_partno => r.partno, p_synonym_of => r.synonym_of, p_value_lines => COALESCE (r.value_lines, 0) + COALESCE (r.repl_value_lines, 0),
The function DBMS_XMLGEN.GETXMLTYPE(query) was changed: If the parameter is a simple string, a syntax check will be done on that string.
The following new rules were added:
Rule 6703 ("Replace IF ... CONTINUE by CONTINUE WHEN.")
Rule 6705 ("An IF having ELSIF clauses should have an ELSE clause.")
Rule 6711 ("Search literal following LIKE should contain wildcards _ or %.")
Rule 6713 ("Isolated semicolon(s) found.")
Rule 6714 ("Duplicate CASE WHEN entry found.")
Rule 6715 ("COMPRESS or NOCOMPRESS specified more than once.")
Rule 6724 ("Check on PL/SQL block and loop label matching.")
Rule 6726 ("Consider replacing '(NOT) IN subquery' by '(NOT) EXISTS subquery'.")
Rule 6727 ("NVL in a WHERE clause may disable the use of an index.")
Rule 6731 ("A WHERE condition containing the (+) operator cannot be combined with another condition using the OR logical operator.")
The following is a list of enhancements requested by Toad for Oracle users on the Toad Idea Pond and implemented in this release.
The 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 people. The Toad development team has always been driven by our customers, and the Idea Pond makes it easy for you to tell us what changes are most important. This site is free for all Toad customers.
|Enhancement||Link to Idea Pond|
|When creating a user script, there is no option to exclude directory grants.||Link|
|Centralize -invalid objects||Link|
|Export Dataset to default to and find XLSX files||Link|
Dual Monitor Support
The following items were removed from Toad in this release:
The following items were removed from Toad options. Toad will always behave as if the options were checked.