Toad for Oracle 2023 R2 Patch 1 Edition 17.0.353.2906 (x86 / x64)

Toad for Oracle is a database development and management toolset that reduces the time and effort developers and DBAs spend on daily tasks. Save time and reduce risks with the leading Oracle database development and optimization software tool, as ranked by IDC.

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.0

Oracle 23c
Support for new features in Create/Alter windows, generated scripts, and elsewhere as appropriate:

• ANNOTATIONS
• Boolean datatypes
• DEFAULT ON NULL FOR INSERT AND UPDATE
• DOMAINS
• IF [NOT] EXISTS
• JSON-Relational Duality Views
• PRECHECK Constraints
• Schema-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 execution
• Option added to trim whitespace when saving files
• Improved performance when the Navigator option to "Show references" is unchecked; also applies to the Schema Browser when viewing PL/SQL objects
• Improved 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 versa
• Exporting all Script Output data grids to an Excel file now produces a summary sheet
• Old, automatic backups are purged for improved performance
• Option 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 similar
• Clientless connections support TCPS protocol
• Common 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 files
  • Filter by file content, e.g. SQL ID, tablename, or any text that may exist in the trace file
  • Limit files to only those produced within a specified timeframe
  • Option 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 palette
• Export Dataset action can pass variables to SQL files as parameters

Data Grids

• Columns can be sorted even when the query contains an ORDER BY clause
• Find Data and Filter Data from the context menu allows searching and filtering across multiple columns
• A refresh button has been added to the Editor Data Grid to reexecute the query
• Single 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 filenames
• An option has been added to include private synonyms for objects when exporting

Schema Browser

• Improved performance when selecting Procedures, Functions, and Packages
• Added 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