Toad for Oracle 2024 Edition 17.1.717.3711 (x86/x64)

Only Toad empowers you to:
Implement consistent and repeatable processes, supporting agile DB development.Accelerate application delivery, while minimizing risks associated with database changes.Ensure functional accuracy and scalability with automated testing.Quickly pinpoint and resolve database performance inefficiencies.Automate SQL optimization.Automate and schedule complex or routine database tasks.
Simplified database development
Design, build, edit, debug and manage projects with Toad Data Modeler, and built-in Database Browser, SQL Editor, Debugger and Project Manager.
Code quality assurance
Collaborate with team members and standardize code formatting while preserving code integrity and preventing overwrites with included Team Coding and version control.
Automated code testing
Automate the creation and execution of functional code tests to ensure application quality and enable faster delivery of quality code with Code Tester.
Automated code analysis
Automate code reviews using industry best practices and predefined and/or customizable rulesets in categories such as readability, correctness, program structure, naming conventions and maintainability, with Code Analysis.
Automated performance optimization
Pinpoint database bottlenecks with Spotlight database diagnostics and resolve issues quickly or validate SQL, PL/SQL and indexes to ensure high performance through the only automated SQL tuning toolset, SQL Optimizer.
Database performance testing
Conduct performance and scalability testing as well as industry-standard benchmark testing in pre-production with Benchmark Factory tool to ensure any database changes made will scale under user and transaction load.
Database health and stability
Assess your database's health and generate reports on over 200 aspects of database performance, configuration, schemas and security vulnerabilities with Toad DB Admin Module's Database Health Checks.
Team collaboration
Share code, scripts, artifacts, standards and best practices with the team or across the development organization through integration with Toad Intelligence Central application.
Risk mitigation and automation
Automate complex, frequent or repetitive tasks and processes including schema compares, script execution, administration (users and permissions), report generation, SQL optimization and more with Toad Automation Designer and its Toad Apps to save an enormous amount of time and reduce the risk of manual errors.
What's new in Toad for Oracle 17
Oracle 23c
Support for new features in Create/Alter windows, generated scripts, and elsewhere as appropriate:
ANNOTATIONSBoolean datatypesDEFAULT ON NULL FOR INSERT AND UPDATEDOMAINSIF [NOT] EXISTSJSON-Relational Duality ViewsPRECHECK ConstraintsSchema-level privileges
Editor
Data grids can be pinned allowing for multiple statements to be executed within a single tab without losing the results of the previous executionOption added to trim whitespace when saving filesImproved performance when the Navigator option to "Show references" is unchecked; also applies to the Schema Browser when viewing PL/SQL objectsImproved performance of parameter assistance for Oracle built-in functions defined within the SYS.STANDARD package, e.g. TO_CHAR()Added an option to the Script Output tab that synchronizes the Editor caret position with the active Script Output data grid and vice versaExporting all Script Output data grids to an Excel file now produces a summary sheetOld, automatic backups are purged for improved performanceOption added to enable utPLSQL integration if it is installed; unchecking this option improves performance by eliminating internal queries, but disables all Editor support for utPLSQL test suites
Connections
SSH connections can be made natively without needing PuTTY or similarClientless connections support TCPS protocolCommon users having the SET CONTAINER privilege can easily switch between CDB and PDB instances via the Connection Bar context menu
Connection Colors
An option has been added to fill Toad's title bar with the active connection's color when using a color scheme and connection colors
Trace File Browser
Improved workflow when loading files from the database server
Option to exclude non-SQL trace filesFilter by file content, e.g. SQL ID, tablename, or any text that may exist in the trace fileLimit files to only those produced within a specified timeframeOption to preview files after retrieval
Object Palette
Option added to "Show Subobjects" that displays related objects (e.g. table constraints, grants, indexes, triggers, etc.) just like the Schema Browser's "Show LHS Subobjects" feature
Automation Designer
Improved Action paletteExport Dataset action can pass variables to SQL files as parameters
Data Grids
Columns can be sorted even when the query contains an ORDER BY clauseFind Data and Filter Data from the context menu allows searching and filtering across multiple columnsA refresh button has been added to the Editor Data Grid to reexecute the querySingle Record Viewer supports copying the column header and value to clipboard
Compare Schemas
Options added to verify that tablespaces and Oracle features exists in the target database; any violations that will cause the sync script to fail are identified in the Difference Details tab
Generate Schema Script
Added the ability to combine related objects when generating one script per object; for example, synonyms and grants with their target objects, type/package with its body, indexes with their table, etc.An option has been added to include schema name in object filenamesAn option has been added to include private synonyms for objects when exporting
Schema Browser
Improved performance when selecting Procedures, Functions, and PackagesAdded the ability to pin quick filters
Session Browser
"Kill Session" button added to the Locks tab"Status" column added to the Locks tab
Import Table Data
Added the ability to create a new table from the Import Table Data wizard prior to importing
Workspaces
New command line parameter for launching Toad and opening a specific workspace, e.g. Toad.exe -workspace my_favorite_workspace_name
Debugger
A new "Check Privileges" menu item is available from the main Debug menu to check the active connection for the privileges required to debug
DB Health Scan (Preview)
DB Health Scan is a new window similar to DB Health Check with improved visualization of results. This window is a preview feature with additional improvements planned for a future release.
SQL*Net Editor
Added support for SSL parameters
TNSNames Editor
Added support for Retry Delay, Retry Count, and Compression parameters