New in TOAD for Oracle 13.3.0.181 (Aug 17, 2020)
- New Features and Enhancements:
- 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.
- 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.
- 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.