-
Title
What's new in Toad For Oracle 12.11? -
Description
This article contains some new features released with version 12.11. -
Resolution
New Features
The following new features were introduced in this release of Toad for Oracle.
Cloud supportToad now enables simple movement to and from cloud-based Oracle installations. Pluggable databases cannow be cloned from one server to another through a database link instead of having to manually copy files.
Toad Intelligence Central IntegrationThe execution of artifacts from Toad in Toad Intelligence Central has been removed.
Team Coding-The ability to view annotations for VCS files has been added to the Object Properties window in TeamCoding. Annotations allow you to view the line-by-line contents of a file, as well as the revision and theauthor who made the change. Hovering over the revision number in this tab shows details for therevision in a hint.- Team Coding now enables you to add unit tests to the VCS. This applies to unit tests created within Toadfrom the PL/SQL Results window. To enable this feature, add the schema of the user that created the unittests to a team project, then select the Unit Test object type under that schema.
Session Menu-Session | New Connection now displays all possible connection types in the Connect As drop-downlist, including SYSBACKUP, SYSDG, and SYSKM for Oracle 12c.
Schema Browser-The Schema Browser right-hand side Deps tabs now has an option to send all or selected objects to theExport DDL window.-Toad now supports the granting of the Common role in the Create/Alter User command, as well as inthe Users | Role Grants, and Users | Script tabs.
Database-The new Compare Schemas Wizard provides an easier to use interface for doing a one-to-onecomparison between schemas. One of the unique features of the Wizard is to allow for the adding orchecking in of the generated script to source control.-The new Compare Multiple Tables feature allows you to compare and synchronize multiple tablesbetween two schemas.
Editor-An Errors tab has been added to the Script Output window of the Editor. This will provide quick accessto error information when executing code as a script.-The Editor debugger now allows selecting from a table as an input argument value. Type the SELECTstatement in the Input column of the grid in on the Arguments tab of the Set Parameters dialog, and thenset Input Type to Expression. The SELECT is shown in the Anonymous Block code window with therequired INTO statement. To avoid Oracle errors when the block is executed, make sure that theSELECT limits rows properly. The query must return a single value (one column, one row).
Automation DesignerThe Automation Designer now has a Query Iterator, which enables you to enter a query, and for eachrow in the result set, one or more child actions does something with the query result. For example, thequery could select a list of tables, and then Toad could run some action with each of those values. TheQuery Iterator is the only iterator in Toad that produces multiple variables (one for each column of yourSELECT statement).
*******Additional information relating to the new features in version 12.11 can be found in the Toad for Oracle12.11 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)