Toad for Oracle & Toad for Oracle on Mac 17.1 (17.1.717.3711) is now available

Introducing Toad for Oracle 17.1 : AI-Powered Insights at Your Fingertips! We’re thrilled to announce the launch of Toad for Oracle 17.1 (17.1.717.3711), the latest iteration designed to turbocharge your database management and development. This release is packed with features that will not only optimize your workflow but also secure your data like never before. We’re bringing you a groundbreaking feature that will transform the way you interact with SQL: the preview of AIExplain.

AIExplain (Preview): Simplifying Complexity Dive into the depths of your database with ease! Our AIExplain (Preview) feature demystifies the SQL statements in your editor and for triggers, views, functions, procedures, and packages. It’s like having an AI-powered oracle, offering insights and clarity into your database operations.

Clarity in Complexity No more head-scratching over complex SQL statements. With the preview of AIExplain, you’ll get:

  • Instant explanations: Understand the purpose and impact of your SQL code at-a-glance.
  • Optimized performance: Identify and resolve bottlenecks faster than ever.
  • Enhanced learning: Learn SQL best practices as you work, improving your skills on the fly.

Uncompromised Security: Your Data, Your Rules We understand the importance of data privacy. Your AIExplain (Preview) data remains confidential and secure, never shared with any third party. Your trust is our priority, and we’re committed to upholding it with the highest standards of data protection.

Mac Enhancements: Secure and Stylish For our Mac users, we’ve introduced more security enhancements to keep your data safer than ever. Alongside, we’ve refined the editor and data grid with a more consistent look and feel, ensuring a seamless and more intuitive user experience.

Customer-Driven Improvements Your feedback is invaluable, and we’ve listened! This update includes numerous enhancements directly influenced by our dedicated users. Expect a smoother, faster, and more secure Toad with:

  • Robust security updates: Protecting your data is our top priority.
  • Performance boosts: Experience the most efficient Toad yet.
  • Usability refinements: Navigate with ease and accomplish more with less effort.

Bug Fixes: Smoother Sailing Ahead We’ve squashed those pesky bugs to ensure your Toad experience is as smooth as possible. Enjoy uninterrupted productivity and peace of mind with our latest bug fixes.

Ready to Upgrade? Don’t miss out on the opportunity to transform your database management with Toad for Oracle 17.1. Embrace the power of AI and enjoy a fortified, user-friendly platform that’s been shaped by you, for you.

Read our blog to learn more about the preview of AIExplain and how to try it out today.

For more information on this release including these enhancements and other stability and performance improvements, view the release notes at https://support.quest.com/technical-documents/toad-for-oracle/release-notes .

Get your subscription today by going to Toad for Oracle Subscription or Toad for Oracle on Mac Subscription Quest Online Store.

To learn more about Toad for Oracle, visit https://www.quest.com/products/toad-for-oracle.

To download this latest release, visit https://support.quest.com/toad-for-oracle/download-new-releases for Windows and https://support.quest.com/toad-for-oracle-on-mac/download-new-releases for Mac.

Change Log

Bug Fixes

  • Alter Database Link: DB Link name appearing in User Name field
  • Alter Datafile: Error when specifying file size greater than 2147483647 bytes
  • Alter Refresh Group: Added support for Oracle 18 changes around refresh group job management from DBMS_JOB to Scheduler Jobs
  • Alter Table: "Rename column" command including schema when user requested to exclude schema Link
  • Analyze Objects: Access violation if window closed while refreshing
  • Application Logging: Not fully working after auto-restart
  • Automation Designer:
    • Access violation when changing connection to "none"
    • Access violation when running script action after switching to another window, then back to Automation Designer.
    • Cannot import Data Pump Import actions from prior versions
    • Format Files action only affecting case of reserved words
    • Format Files action corrupts line feeds
    • Export Dataset to Excel File actions changing file extension Link
    • Export Dataset allowed CSV extension for Excel File format (should be delimited) Link
    • Format Files action changing files to Unix style line feeds
  • AWR Browser: Insufficient privs error from AWR report when connected to pluggable DB
  • Blob Editor: Files saving without an extension Link
  • Code Analysis:
    • Not running after editor open, then closed
    • Toad crashing after running SQL Scan in some environments
  • Code Road Map: "File in use" error when multiple Toads running
  • Compare Data:
    • Source schema changing when connecting target connection
    • Unable to compare tables when column name contains asterisk
  • Compare Multiple Tables: "[] is not a valid directory" error if output file name specified without path
  • Compare Schemas: "Create" used instead of "Create or Replace" if using parameter file from Toad 16.3 or older
  • Connection Bar:
    • List of containers not always fully populated Link
    • Alter session set container" in Editor caused container indicator on connection bar to get out of sync. Link
    • "Frequently Used" windows can be launched in the wrong connection. Link
    • "Restore Lost Connections" menu item not always enabled when it should be. Link
  • Connections:
    • Access violation if ending connection while quick describe window is open
    • ORA-00045 (session terminated with noreplay) not displayed with option to reconnect
    • "Cannot perform this operation on a closed dataset" error after lost connection
    • "Search this message" link goes to wrong place in connection error dialog
  • Create DB Link: "Use full TNS Info" option not available in no-client mode
  • Create Pluggable Database: Error when creating from clone through DB Link
  • Create/Alter DB Object:
    • Show SQL w/o Schema still showing schema when adding foreign key
  • Dark Mode:
    • Editor's "Load Database Objects" not painted correctly until SQL finishes
    • Ghosty lines around toolbars on high-dpi displays. Link
    • Long error messages cut off text instead of word-wrapping
    • Removed a white square in the corner between vertical and horizontal editor scrollbars
  • Data Grids:
    • ORA-00001 and connection lost in no-client mode after refeshing a grid when '@' exists in the SQL Link
    • Date popup sometimes displays "You must be in ShowCheckbox mode to set this date"
    • Grid Find dialog auto-selecting too many columns Link
    • Record Count does not respect filter Link
    • Some columns auto-sized too narrow on scaled displays. Link
    • Time zone information incorrect when connected without Oracle client
  • Data Import Wizard:
    • Can't import '1.0' from text file into an integer column
    • Dots and dashes not handled in custom date format Link
    • First character of each line missed if file has Mac-style line feeds
  • Database Browser: Access Violation from Quick Filter if it contains too many items
  • Debugging: "Invalid Oracle Home" when trying to debug in no-client mode
  • Editor:
    • Backing up files immediately after being drug into Toad
    • "DB Object newer than editor contents" prompts with each F9
    • Load DB Object window not remembering last object type Link
    • Access violation when running SQL that contains control characters
    • Access violation while debugging certain objects
    • Excessive scrollbar movement when navigator reloads (most noticeable when a color theme is applied)
    • Focus not always changing to new tab Link
    • Goto line (CTRL+G) caused access violation. Link
    • Incorrect error line reported after compile. Link
    • "Save as" including full path in file dialog
    • Shortcut for Print Preview cannot be changed. Link
    • Tab stop setting not saved
    • Toolbars not wide enough in Dark Mode, hiding buttons in favor of dropdown arrows
  • Export Dataset:
    • Clobs more than 32K in length not exporting at all to Excel files
    • Default Excel format was XLS instead of XLSX. Link
    • ORA-00936 "missing expression" error if user changes connection on export dataset dialog to a connection which does not have the tables being exported
    • Substitution variables not being set after editing SQL Text Link
  • Export DDL:
    • "Invalid Table Name" error when creating scripts in Oracle 23c
    • "Alter user X default role all" incorrectly appearing when only one role granted
    • Constraints longer than 4000 characters getting truncated in scripts
  • External Tools: Tool names not displayed properly on scaled displays
  • FTP: Invalid private key file raised exception instead of "nice" error
  • GUI: Text cut off in Options and About window under high DPI
  • Help->About: Version number gets appended after changing tabs
  • Import Table Data:
    • Access violation when re-running import and Excel sheet no longer in file
    • Error if Array Size value too large.
    • Exception raised if importing from Excel and the sheet to be imported is missing:
    • Fixed field width imports giving bogus error about field size
  • LDAP Editor: Forced entry of primary port
  • Load DB Object Dialog: Gray square displayed when "Show Source" left unchecked Link
  • Login Window:
    • Add, Test Connection gave "SSH Host Required" message
    • Buttons not displaying properly in Windows Server 2016. Link
    • "Connect Method" column not being populated
    • Edit Dialog: Password shown in clear text when entering new password for multiple login records:
    • LDAP dropdown in no-client mode was painfully slow
    • LDAP entries not sorted when using Oracle client
    • RHS Control values overwritten on clicking CONNECT after editing alias in grid Link
    • TNSPing button giving bogus error if TNSPing.exe not found
    • TNSPing button not working on LDAP entries
    • Grid filtering by client while in no-client mode
  • Master-Detail Browser: Filter being compressed to one line in SQL, sometimes causing error Link
  • Misc Dialogs: Modal Dialogs sometimes appearing on different display than main Toad window
  • Multiple Toads: Improved protection against multiple Toads from accessing ini files at the same time
  • No client mode: Access violation when selecting RAW through DB Link
  • Options:
    • "Allow internet access" not disabling Toad Improvement Program
    • "Allow multiple Toads" option not respecting Toad version
    • Can't change application data directory
    • Font Ligature hint applied to every checkbox in Options|Editor|Display
  • Project Manager: Can't launch file in external editor (or SQL*Plus)
  • Schema Browser:
    • Access violation if changing RHS dimension tabs while script is loading
    • Common Unified Audit Policies created in container DB not visible in pluggable
    • Data grids loading slowly if "include column ID in grid column header" option is checked
    • DB Link dependencies finding links in other schemas
    • Error when clearing data grid filters, "Cannot find the path specified"
    • Incorrect tab order in Filter/Sort dialog. Link
    • Invalid Objects filter not applying to indexes
    • Quick Filter didn't work for Favorites
    • RHS Script buttons - icon should match the LHS script button.
    • RHS Tablespace Free space tab not always consistent with Datafiles tab
    • Tabbing from the quick filter goes to no-man's land
    • Tables, Script tab: If table contains an identity column, a bogus "drop sequence" command was produced
    • Treeview clipping text on scaled displays
  • Schema Compare: Error - 'Nothing selected to compare' when constraints selected
  • Script Execution:
    • Desc not including procs without parameters Link
    • Execution time sometimes wrong. Link.
  • Script Manager: Access violation when running scripts
  • Session Browser: Too responsive to fast clicking on LHS Link
  • Single Object Compare: Running more queries than needed while selecting objects Link
  • Startup: "Scheduler is not running" error if windows scheduler is not running
  • Statspack Browser: CTRL+C caused temporary freeze in SQL Summary Grid Link
  • Team Coding:
    • "Object source has changed" dialog appearing in a loop on checkin
    • Exception on Check-in with comment longer than 200 chars (up to 1000 now allowed)
    • Lock message showing wrong user name
  • TNSNames Editor: Can't add new service
  • Toad Script Runner:
    • Access violation when closing
    • "Save as" not creating XLS/XLSX files
    • Tabs don't look right in dark mode
  • Toad on Mac:
    • Blob Editor not showing Save dialog correctly.
    • Can't drag-drop from Mac's Finder to Toad's editor to open files
    • Caps lock getting confused
    • Caps lock slowing down editor load time
    • Compiling Team Coding controlled object using shortcut causes an endless loop
    • F3 (Find Next) not working if dialog not visible
    • Fast Exit does not shut down Toad
    • Grid lines not visible in some grids.
    • License expiration warning text cut off
    • Registry warning in Toad Advisor
    • Some buttons not drawing correctly in dark mode
  • Toolbars: Access violation if toolbars reset while describe window open
  • Trace File Browser: Trace files containing "Call Stack Trace" sections caused parse error
  • Unit Test Manager:
    • Connection changing unexpectedly when clicking in tree. Link.
    • Connection changing unexpectedly when closing. Link.
  • Window Bar: Connection Color square around Describe Objects not drawn correctly
  • Window Menu: Grows each time you click it. Link
  • Workspaces: Access violation while workspace loading due to backup engine firing right away. Link

Enhancements

  • Application Logging: A notification now indicates when enabled (right-click to silence)
  • Automation Designer:
    • Added a VERY advanced feature to make bulk edits to all selected apps or actions Link.
    • Apps/actions can now be enabled/disabled by right-click. Disabled actions will not run
    • Content type (plain or HTML) can now be specified in email actions
    • Option added to script action to not display popup error messages
    • Script Execution: Error codes added to the "ignore error list" are now auto-checked when you add them.
    • ToadActions.dat is now written in a manner that is safer for multiple Toads running
    • Variables are now supported for connections and source/target schemas in Generate Schema/DB Script, and Compare Schema/DB actions Link
  • Compare Schemas, Export DDL, Generate Schema Script: Added option to exclude EDITIONABLE/NONEDITIONABLE. Link
  • Connection Bar and Window Bar: Middle-click now closes a connection or window
  • Connection Bar Buttons: "As SYSDBA" is now optional. Link
  • Connection Colors: Colored squares on connection and window bar buttons are now thicker Link
  • Connections:
    • Added ability to disconnect sessions w/o closing windows (the purpose of this is so you can disconnect from DB to avoid a more forceful disconnect from the server side, which might result in a slow reconnect process)
    • Added an option to prevent Toad from attempting to use SYS.USER$. Link
    • LDAP Secure Port 636 is supported in no-client mode
    • Server Access/Audit messages now displayed in no-client mode
  • Create Unified Audit Policy: "Container=ALL" can now be specified
  • Create/Alter Datafile:
    • Can now add multiple datafiles at once
    • Find/Copy now lists default disk group (ASM)
  • Create/Alter Schedules and Scheduler Jobs: Added buttons for sample start/end times
  • Create/Alter DB Objects: "Show SQL without Schema" feature now more obvious
  • Data Grids:
    • Popup Blob viewer can now preview contents as PDF, XLSX, DOCX (first page only), Text, Image, or Hex
    • Popup menu is now customizable. Rearrange menu items and hide what you don't want to see.
    • Single Record View now displays connection info and, if launched from Schema Browser or Master-Detail Browser, table name
  • Data Subset Wizard: Minor UI enhancements
  • DB Health Scan: GUI enhancements
  • Describe Objects: Object list settings file (DescribeWindowList.xml) is now automatically backed up Link
  • Editor:
    • Script Execution: A summary grid, to summarize the other grids, has been added
    • Double-click on error in script output no longer opens web browser. Link.
    • Save breakpoints between debug sessions
    • Toad now attempts to stay on current line after a file is reloaded in the editor Link
  • Export Dataset: Add support to run non-select statements in the script Link
  • IVP6:
    • Now supported in FTP, SFTP, RExec, SSH
    • Now supported in no-client connections
  • Generate Schema Script: Add variable support to "Top Level Directory" field. Link
  • Log Switch Frequency Map: Can now show size/quantity of Archive Log switches
  • Login Window:
    • Add option to start focus in Grid or "User" box
    • Moved the checkboxes from the bottom of the window into the "Display Style" dropdown on the toolbar above the grid
    • Remember last focused column in grid
    • TNSPing button now returns actual TNSPing output
  • New Beta Notification: Less wordy and no "OK, I'll start downloading now" message
  • Menu (Toolbar reset required):
    • Session Menu: Wording and grouping improved
    • Window Menu: Removed Download Manager
    • Window Menu: Added "Tile Selected Windows"
  • Master-Detail Browser: Filter dropdown is now the same as Schema Browser Link
  • Options: If Options|Oracle|General->OCI Array Buffer Size is Set to Manual, Toad no longer performs an "OCI Describe" before executing SQL for grids. OCI Describe was preventing Adaptive Cursor Sharing from working correctly Link
  • QSR:
    • Now supports F2 functionality to move the splitter up/down, same as Toad's editor
    • Shows connection info on title bar like Toad
    • There is now a dropdown arrow on the tab control, making it easier to look through and select from a long list of tabs
  • Schema Browser:
    • Favorites Expansion state is now saved/restored automatically
    • Can now multi-select tablespaces and choose "Add datafile" to add a file to each selected tablespace
    • Create DML Procedures dialog now has an option to restore default settings
    • Added some Schema Browser actions to Options -> Toolbars -> Shortcuts
    • Commit/Rollback buttons above data grids now only enabled when in transaction
    • Create Insert for All Rows Data substitution feature added. Link
    • Favorites - Annoying "# Objects Added" message removed
    • In LHS, CTRL+F now moves focus to the quick filter
    • Quick Filters can now be saved per-connection. Link
    • Run Scheduler Job's "Ok, I did it" message is now no-nag.
    • Tables-RHS-Indexes - creation date can now be displayed (click top-left corner of grid to enable)
    • Tables-RHS-Stats/Size - index size can now be included
    • Tablespaces RHS Free space tab can now display storage occupied by recycle bin objects
    • Tablespaces RHS Objects tab now has a button that allows you to rebuild/move selected objects within the same or a different tablespace. This can be handy when you need to shrink datafiles but objects at the end of the file are preventing that
  • Script Execution: The animation on the progress dialog has been replaced with a standard progress bar
  • Session Browser:
    • Can now start/stop tracing database-wide (as opposed to selected sessions)
    • Display active filter name Link
    • Trace Session now has "include waits" checked by default
  • Spool SQL: OCI Describe events are now spooled
  • Tablespace Map: Can now display the contents of a single datafile in multi-file tablespaces
  • Team Coding: Much faster now when working with multiple objects (check in/out, etc)
  • Toad on Mac:
    • File menu items moved to Apple file menu
    • Improved fonts for Editor and Data Grids
    • Make TNS_ADMIN location easy to locate
  • Toolbars: New toolbar buttons will now be displayed in upgraded versions of Toad, if toolbars were never customized
  • Trace File Browser:
    • A histogram has been added to "Wait Summary" tab
    • Added a Min/Avg column in wait summary tab. This can be helpful in finding statements have that a particularly long wait
    • Added advice for more wait events
    • Now automatically identifies cases where a cursor loop drives a SQL with binds (in which case performance could be improved by removing the loop and joining the SQL
    • Start/End times, as well as a gantt chart showing this info, and some additional columns like Executions, Fetches, Parses, has been added to the Preview File dialog
    • The data at the top of "Query Summary" has been reorganized to a new "File Header" tab. Some of the info has been moved to the "File Header" tab.
    • The worst performing statement is now highlighted in red
    • You can now add notes on a SQL statement
  • Export DDL: Much faster now when exporting multiple objects. Please note, this change means that in some cases the output files from Export DDL may be slightly different. Specifically:
    • When exporting multiple objects to either "One file per schema" or "One file per object type", the order of the statements in the file may be different than before.
    • When exporting multiple objects to either "One file per schema" or "One file per object type", line feeds between statements may be different than before
    • "BuildAll.sql" is now "Build_All.sql". This change was made so that Generate Schema Script and Export DDL produce the same file name.
    • When exporting objects to "One File per Object" in Generate Schema Script - an additional line feed is present at the end of each file as compared to version 17.0.
  • What's new dialog: Links now open in default browser
  • Workspaces:
    • Auto-Save/Load options are now separate. Link.
    • "Save" now saves without prompts
    • New "Save as..." can be used to save to a new workspace
    • "Delete" and "Rename" options now show additional info about workspace

The change log for Toad version 17.0 is here

1 Like