Toad® for Oracle 13.2 was in beta for about a year. During that time, we made lots of improvements! Since today it's Halloween, and this is Toad 13, I chose 13 improvements to share with you today. **This blog was originally published on Halloween, Oct. 31, 2019 and has been updated to include essential links.**
1. New unit testing built on utPLSQL
A GUI front-end for the popular open source unit testing suite, utPLSQL. Create and run unit tests, and review test results.
2. Sensitive Data Protection
You can now define default audit, encryption, and redaction policy options, as well as custom user-defined severity categories, to individual sensitive data rules. Once defined, those policies can then be applied to a group of columns by selecting the columns in question and selecting “Apply Default Policies”. This allows you to set up policies on multiple columns at once rather than individually.
Main Menu: View -> Toad Options -> Sensitive Data
Main Menu: Database -> Report -> Sensitive Data Protection Search
3. Updated Create/Alter DB Object windows
These windows have an updated look. Here’s a screen shot of the new Alter Table window (there are about 40 others!)
Main Menu: Database -> Create -> Table
4. Updated Analyze Objects window
Analyze Objects has a new, easy-to-use workflow, and is now supported in the Automation Designer.
Main Menu: Database -> Optimize -> Analyze Objects
5. Export/Import connections
- Now includes password (protected by master password)
- Windows 10 support
- Oracle 19c support
- FIPS compliance
- It is no longer necessary to manually include .GetCLOBVal() in your queries with XMLTYPE. This now happens automatically behind the scenes.
- XMLTYPE data is now editable in the popup editor (just include ROWID in your query).
8. Data Compare window
- Supports BLOB, CLOB, NCLOB, XMLTYPE
- A differences report can now be created (also in Compare Multiple Tables)
9. Export Dataset
- Now Faster!
- Enable/disable auto file name (based on table exporting from) by right-click in the “filename” box.
- Can now specify “where” clause for tables being exported.
10. Team Coding
- All VCS and Team Coding settings can now be backed up/restored to the server using new toolbar buttons on the Team Coding Configuration window.
11. Code Analysis
- Several new and updated analysis rules.
12. Sensitive Data Protection
- Added regular expression rules for common identification names and formats used throughout the European Union.
- Added an "examples" box and "test" button to the rules window, so you can test rules as you are adding them.
- Added a "severity" field to the rules window to allow for user-defined rule management and organization.
13. Automation Designer/Task Scheduler
- New, easy migration of scheduled Toad actions from prior Toad version to 13.2.
That's it for now. Toad for Oracle 13.2 is available now in all Toad for Oracle editions.
Try Toad free for 30 days.
Join the more than 60% of Toad users who report saving at least an hour's work per day. Try toad for free for 30 days.
Already in a trial? Talk to sales or buy now online.
Already a loyal fan of Toad for Oracle? Renew now.
Have questions, comments, or an idea for a new feature?
Head over to the Toad for Oracle forum on Toad World®! Chat with the me, the other Toad developers, and lots of experienced users.
Author: John Dorlon, Quest Software