Toad™ for Oracle® 12.11
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 for using the latest Toad features.
The Toad 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 receive a certificate of completion for each course once you pass the accompanying test!
Toad 12.11 is a minor release, with enhanced features and functionality.
All commercial versions of Toad 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 Edition and the minimum system requirements for running these products, see the Toad for Oracle 2017 Editions release notes at:
The following new features were introduced in this release of Toad for Oracle.
Toad now enables simple movement to and from cloud-based Oracle installations. Pluggable databases can now be cloned from one server to another through a database link instead of having to manually copy files.
The execution of artifacts from Toad in Toad Intelligence Central has been removed.
The Create Unit Test command (on the PL/SQL Results tab) now enables you to attach new test cases to an existing test definition. To do this, select Attach To Existing in the Create Test Case dialog.
The following changes were made to the Utilities | Compare Files utility:
The TNS Names editor has been redesigned for better overall usability. This new editor functions similarly to Toad's regular Editor, with a main editor and a tabbed navigation panel on the left hand side. You can still create, edit, clone, and delete entries visually, but the new editor provides a cleaner way of working with TNS files directly. Additional features include:
Ability to open more than two files
Ability to compare the contents of two tabs in the editor, or between a file on a tab and an external file.
Support for multiple TNS entry formats
Ability to view the left-hand side by host or by service
Ability to view cases where multiple items exist for a node. When viewing in host mode, this can be useful in detecting duplicate TNS entries with different names.
Export Dataset with the Delimited Text format selected now includes a quick way to create an IN list for your SQL from field values in a grid. Select the Export as "in" list for SQL check box and then select a column to get a preformatted IN statement of the data in the specified file. This feature is only available when right-clicking from a grid and multiple rows are selected from only one column. Note: This setting is NOT remembered from one action to the next because it is tied to the grid and requires only one column to be selected.
The following is a list of enhancements requested by Toad 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|
|Add additional navigator options||Link|
|Add Configuration Option for behaviour of undoCheckout||Link|
|Copy Visible Grid Column Names to Clipboard||Link|
|Sort capabilities on the Action Recall window in Automation Designer||Link|
|Add dates from v$log to online redo query in LogMiner||Link|
|Display Saved Filter Name for Data Grids||Link|
|Stop script execution in Script Manager on error.||Link|
|Multiple Scripts in Reports Manager||Link|
|Comment with timestamp in Editor||Link|
Improve Team Coding messaging. When Log VCS commands in the output window is selected, the following is the new behavior:
This section contains a list of the issues that were resolved in this release of Toad for Oracle.
|Resolved Issue||Issue ID|
|Breaking a lock in Team Coding doesn't update the VCS||TOR-1415|
|Issue found in Schema Browser refresh for TC objects||TOR-1411|
|Reporting GMT time in its history, rather than local time||TOR-1346|
|Temporal Validity not supported in table scripts||TOR-1345|
|Export File Browser hanging||TOR-1333|
|Can't debug on Pluggable RAC||TOR-1330|
|List Index Out of Bounds error when comparing large files||TOR-1310|
|Session Browser Disconnect Sessions and Kill Session buttons not active when setting DBA Role||TOR-1277|
|AV when formatting files with Execute Queries in Threads option turned on||TOR-1265|
|12c: Users > Object grants tab uses bad query for low priv users||TOR-1259|
|Explain plan window does not display content properly in Session Browser||TOR-1256|
|Scheduler Jobs notifications not created when Schema is different than login schema||TOR-1255|
|Minimum size for tablespece file definition is computed incorrectly||TOR-1236|
|Anonymous Block with Bind Variable Executing Twice||TOR-1225|
|Cursor jumps when dragging from OP to Editor||TOR-1224|
|Scheduler Jobs > Scheduled Run Times tab not showing correct run times||TOR-1222|
|ora-00936 Missing Expression when clicking on the Locks | System tab of Session Browser||TOR-1219|
|Add scrollbars to data compare||TOR-1218|
|When importing from *.xls version 5.0/95, Dates import as numbers||TOR-1210|
|Toad: FTP tool in Toad shows incorrect modified timestamp when connected via Secure FTP||TOR-1180|
|Named SQL Drop down list is hard to read||TOR-1031|
|Double-clicking in TC Manager opens VCS version of file vs local copy||TOR-1022|
|Disable "show diff details" for sys-named constraints where DDL cannot be fetched||TOR-1003|
|Alt+Left Arrow does not always take you back to package body||TOR-988|
|Non-SYS User logs in as SYSDBA, sees SYS's objects in dropdown||TOR-940|
|Toad doesn't release memory when 'execute as script' is cancelled||TOR-901|
|Editor: Alignment brackets (block staples) feature removed in 12.7 27 of 27 Return to search||TOR-881|