Toad for Oracle 2024 Edition 17.1.717.3711 (x86/x64)

[CZFXP]

Free Download Toad for Oracle 2024 Edition 17.1.717.3711 (x86 / x64) | 543 MB / 593 MB

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

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





      Code:

Code Select Expand

You are not allowed to view links.

Register or Login
Links are Interchangeable - No Password - Single Extraction