dbForge Studio for Oracle
Version
2026.2.96
License
Shareware
Trial Limitations
Free 30-day trial of the paid editions; a free Express edition with basic features
Operating Systems
Windows 7, 8, 8.1, 10, 11, Windows Server 2008, 2012, 2016, 2019, 2022, 2025, macOS and Linux with CodeWeavers CrossOver
System Requirements
Windows 7/8/8.1/10/11 or Windows Server 2008-2025, .NET Framework 4.7.2 or later. Oracle 8i to 26ai, Oracle Cloud, RAC, Amazon RDS. macOS/Linux via CrossOver
File Size
135.80 MB
Release Date
11/9/2026
Last Updated
11/13/2026
1158 views 3 downloads
Oracle IDE for PL/SQL coding, debugging, schema and data compare, and reports

dbForge Studio for Oracle: A PL/SQL IDE With a Debugger, Schema Compare and Reports in One Window

dbForge Studio for Oracle is Devart's Windows IDE for Oracle developers and DBAs: a PL/SQL editor with smart completion, a step-by-step debugger, a query profiler, schema and data compare with sync scripts, and data reports. The Professional edition costs $329.95 a year (Standard $169.95, Enterprise $429.95, or perpetual licenses from $339.95), and a basic Express edition is free.

If you're juggling Oracle SQL Developer for queries, a separate diff tool for schemas, and Excel for anything that looks like a report, the Studio's pitch is that all of it happens in one place, with the code completion and refactoring you'd expect from a modern IDE.

Quick facts

  • Version: 2026.2.96, released November 9, 2026 (eleven releases so far in 2026)
  • Developer: Devart
  • Platform: Windows 7 to 11 and Windows Server 2008 to 2025, with .NET Framework 4.7.2; macOS and Linux through CodeWeavers CrossOver
  • Databases: Oracle 8i, 9i, 10g, 11g, 12c, 18c, 19c, 21c, 23ai and 26ai, Oracle Cloud, Real Application Clusters and Oracle on Amazon RDS; connects directly without an Oracle client, or through Instant Client
  • Editions: Express (free), Standard, Professional, Enterprise
  • Installer size: 135.80 MB
  • Price: per year, Standard $169.95, Professional $329.95, Enterprise $429.95; perpetual, $339.95, $659.95 and $859.95
  • Trial: 30 days, fully functional (the download asks you to sign in with a free Devart account)
  • Refund: 30-day money-back guarantee on annual subscriptions and perpetual licenses; Devart's ordering FAQ is stricter and refunds only when a technical problem its support can't fix stops the product working
  • What we checked: version 2026.2.96 and its November 9, 2026 date on Devart's download page and revision history, the 135.80 MB installer size listed there, the editions feature matrix, and the order page price of $329.95 for the default Professional 1-year subscription on November 13, 2026. We didn't connect it to our own Oracle database.

Before you buy

  • Schema Compare and Data Compare start at Professional. So do database projects, version control integration, pivot tables, data reports and every command-line feature. Standard is an editor, debugger and profiler.
  • The test data generator and HTML/PDF/Markdown documentation are Enterprise only.
  • A subscription stops working when it ends. A perpetual license keeps working forever and includes a year of updates you can extend.
  • It's a Windows program. On a Mac or Linux it runs only inside CrossOver, which you buy separately.

Download Free TrialBuy Now

Overview

dbForge Studio for Oracle replaced Devart's older OraDeveloper Studio and shares its layout with the company's SQL Server, MySQL and PostgreSQL Studios: a Database Explorer tree on the left, SQL documents in tabs, results in an editable grid, and wizards for comparison, export and import. Its target user writes PL/SQL every day and also has to move schema changes between development, test and production.

It's under active development. Devart shipped eleven builds between January and November 2026. Support for Oracle AI Database 26ai arrived in December 2025, the May 2026 release added index-aware completion and pinned tabs, and the September 2026 release added file attachments and model selection to the AI Assistant, plus a "Last modified" column in schema comparison reports. The October and November builds fixed user-reported bugs such as Query Builder quoting table aliases incorrectly.

Features

A PL/SQL editor that completes JOINs for you

dbForge Studio for Oracle completes keywords, objects and whole JOIN conditions as you type, shows quick information and parameter hints for schema objects and stored routines, and formats code to a profile you set. Snippets, alias and object refactoring, a document outline, execution notifications and a transaction reminder (so you don't leave a session with uncommitted changes) come with Standard and up. The free Express edition has the editor with restricted completion and formatting.

dbForge Studio for Oracle SQL editor suggesting JOIN conditions with the results grid below

Code completion offering JOIN conditions between DEPARTMENTS and EMPLOYEES, with the query's results in the grid and the Sakila schema in Database Explorer.

A step-by-step PL/SQL debugger

dbForge Studio for Oracle debugs stored procedures, functions, packages and SQL scripts line by line. You set breakpoints, watch and change variables in the Watches window, and follow the Call Stack. It's in Standard, Professional and Enterprise, not Express.

dbForge Studio for Oracle debugging a package body with a breakpoint and the Breakpoints window

Debugging the SAKILA.CUSTOMERS package: the current statement highlighted, a breakpoint on the package body, and the Breakpoints window below.

Schema and data compare with sync scripts (Professional)

dbForge Studio for Oracle Professional compares two schemas or the rows of two databases, shows what's only in the source, only in the target or different, and writes a synchronization script you can review before running. Comparisons can be saved, filtered, turned into reports, and run on a schedule from the command line.

dbForge Studio for Oracle data comparison between two databases with the filter menu open

A data comparison of dbforacle9 against dbforcl: 14 tables with differences, the different records of one table below, and the filter and synchronize options.

Query Builder, Query Profiler and database diagrams

dbForge Studio for Oracle builds SELECT statements visually, with joins and subqueries, and writes the SQL for you. The Query Profiler shows a query's execution plan and lets you compare profiling runs after a change. Database diagrams reverse-engineer a schema and show foreign key relations.

Import, export and schema dumps

dbForge Studio for Oracle exports data to 14 formats and imports it from 10, and exports full schemas or selected objects with Zip compression. All paid editions have the wizards; running them from the command line takes Professional.

Pivot tables, data reports and the Master-Detail Browser (Professional)

dbForge Studio for Oracle Professional aggregates data in pivot tables, browses related tables in the Master-Detail Browser, and designs data reports with charts that can be generated and delivered automatically from the command line.

AI Assistant

dbForge Studio for Oracle includes Devart's AI Assistant, which writes queries from plain-language requests using your schema as context, explains and optimizes SQL, and analyzes errors. Query generation, troubleshooting and optimization are listed for every edition, including Express; the chat, SQL explanations and error analysis are listed for the paid editions. Devart added a free Express plan for the AI Assistant itself in September 2026.

Test data and documentation (Enterprise)

dbForge Studio for Oracle Enterprise fills tables with realistic test data from more than 200 generators, also from the command line, and generates database documentation in HTML, PDF and Markdown with the dependencies between objects. Enterprise also adds execution warnings.

Benefits

  • Fewer tools to keep open. Coding, debugging, comparing, exporting and reporting share one connection list and one window.
  • Safer deployments. A compare-then-review-the-script workflow catches the column someone added by hand in production before your release overwrites it.
  • Repeatable jobs. In Professional, the same comparison, export or report you set up in a wizard can run unattended from a .bat file or a scheduler.
  • A gentler learning curve. The Query Builder and visual object editors help analysts and junior developers who aren't fluent in Oracle's data dictionary.

Real-World Uses

  • Release night: compare the test schema with production, read the differences, and run the generated script, with a comparison report saved for the change ticket.
  • A failing package: set a breakpoint in the package body, step through with real parameters, and watch the variable that goes NULL.
  • A slow report query: profile it, change an index or a join, and compare the two profiling runs side by side.
  • A monthly data extract: design the export once, save it as a template, and schedule it from the command line.

Who It's For, and Who Should Skip It

Buy it if Oracle is your daily database on Windows and you want an IDE with stronger coding help, debugging and compare tools than Oracle SQL Developer gives you. Professional is the edition most teams need, because the compare tools are the strongest reason to pay.

Skip it if Oracle SQL Developer's free toolset already covers your work; if you're on a Mac or Linux and don't want to run a Windows program through CrossOver; or if you also work in SQL Server, MySQL or PostgreSQL every day, where Devart's dbForge Edge bundles all four Studios under one license.

Usage Guide

  1. Download and install. Get the trial from Devart's download page (sign in with a free Devart account) and run the installer. On 64-bit Windows with a 32-bit Oracle client, choose the option to add the 32-bit Studio too.
  2. Connect. Create a connection with Direct mode (host, port and SID or service name, no client needed) or through an installed Oracle Home or Instant Client. Color-code it as Production or Development.
  3. Explore and query. Browse schemas in Database Explorer, open a new SQL document, and run queries; edit results right in the grid.
  4. Debug. Open a procedure or package, set breakpoints, and start the debugger from the Debug menu.
  5. Compare (Professional). From the Comparison menu, start a schema or data comparison, pick source and target, review the differences and generate the sync script.
  6. Automate. In a wizard, save the settings and generate the command line to schedule it.

Where It Falls Short

  • The edition split is steep. Standard has no compare tools, reports, pivot tables or command line at all, so its $169.95 price is misleading if those are why you're looking.
  • No native Mac or Linux build. CrossOver adds a separate license and another layer that can misbehave.
  • Bug-fix builds come often. The 2026 revision history lists crash and lag fixes (a crash when working with editors in August, a lag in the table editor) alongside the features. Frequent fixes are good, but expect to update regularly.
  • Lots of menus. With this many tools, finding a rarely used option takes time; Devart's YouTube tutorials help.

What Users Say

dbForge Studio for Oracle has 5 out of 5 from 13 reviews on SoftwareSuggest, written between October 2021 and April 2023. Every one is five stars and most read alike, so take them as a sign of satisfied customers rather than a balanced test. Devart also quotes a few customers on its product page.

SoftwareSuggest (5/5 from 13 reviews)

Telipas O., Software Developer, daily user for 2+ years (April 2023): "The tool provides advanced code editing features and debugging tools for PL/SQL code. It also includes performance analysis tools that allow me to identify performance bottlenecks in my Oracle database and optimize them." He had also used Oracle SQL Developer and DBeaver.

Joseph, Software Developer (January 2023): "I would especially like to highlight the Data and Schema Compare Tools; they are simply out of competition." On the downsides: "I have not found any important points to improve, only some minor issues that were instantly resolved by the support."

Bob W., Back-End Developer (January 2023): "When choosing a stack for a project, we compared many database tools for working with Oracle and eventually chose dbForge Studio. Now we are very satisfied with the functionality and efficiency of the product."

Filipp G. (November 2022): "I can create queries in minutes with Query Builder. Additionally, the complete maintenance of Oracle objects in databases has become much more manageable."

Alex (October 2021): "dbForge Studio for Oracle is more intuitive and much easier to use than the standard Oracle SQL Developer. The installation is simple, and the tool includes all the necessary features for database development and management."

William (February 2022): "The Studio has a significant advantage in functionality compared to other similar tools I tried before purchasing the DEVART product. I especially liked the Master/Detail Browser."

Customer comments on Devart's page

Devart picks these, so read them as the vendor's selection. They include one wish-list item.

Boris Chernysh, System Administrator, PROFI Instrument: "An excellent solution! Principally revised and improved as compared to OraDeveloper Studio. I am now happy with absolutely everything and moving to this product from Oracle SQL Developer."

Pavel Vinogradov, Leading Developer, ISD Ltd.: "The product features an excellent functionality. The one thing it actually lacks is an option to export selected strings as an insert/update script in the Export from Grid mode."

The recurring themes: users praise the compare tools, the PL/SQL editor and debugger, the Query Builder and Devart's support, and several moved over from Oracle SQL Developer or DBeaver. Real criticism is scarce in these reviews, so weigh the price, the edition split and the Windows-only build yourself during the 30-day trial.

Comparisons

dbForge Studio for Oracle vs Oracle SQL Developer

Oracle SQL Developer is free, runs on Windows, macOS and Linux, and covers querying, PL/SQL editing and debugging well. dbForge Studio for Oracle is Windows-only and paid, but its completion, refactoring and formatting go further, and Professional's schema and data compare, pivot tables, reports and command-line automation have no free equivalent in SQL Developer. If you mainly run queries, SQL Developer is enough; if you deploy schema changes or build reports, the Studio earns its price.

Standard vs Professional vs Enterprise

Standard is the coding edition: full completion, refactoring, snippets, debugger, Query Profiler, Query Builder, import and export. Professional adds schema and data compare, database projects, version control, pivot tables, reports, the Master-Detail Browser and the command line. Enterprise adds the test data generator, database documentation and execution warnings.

Editions and Pricing

All editions are sold under one product. The order page opens on Professional with a 1-year subscription; you choose the edition, subscription or perpetual license, 1 to 3 years of support, and optional priority support there.

Edition1-year subscriptionPerpetualWhat it adds
ExpressFreeFreeBasic editor, object editors, data editor
Standard$169.95$339.95Full coding help, debugger, profiler, import and export
Professional$329.95$659.95Schema and data compare, reports, pivot tables, command line
Enterprise$429.95$859.95Test data generator, documentation, execution warnings

Devart takes 5% off for 5 to 9 licenses, 10% for 10 to 19 and 15% for 20 or more.

FAQs

Does dbForge Studio for Oracle need the Oracle client installed?

No. dbForge Studio for Oracle can connect in Direct mode without any Oracle client. It also works with an installed Oracle Home, several Oracle Homes side by side, or Instant Client.

Does dbForge Studio for Oracle support Oracle 23ai and 26ai?

Yes. dbForge Studio for Oracle supports Oracle 8i through 23ai and 26ai (26ai support was added in December 2025), plus Oracle Cloud, RAC and Oracle on Amazon RDS.

Can I run dbForge Studio for Oracle on a Mac?

Only through CodeWeavers CrossOver. dbForge Studio for Oracle is a Windows .NET program, and Devart supports it on macOS and on Ubuntu, Debian, Fedora and Red Hat Linux inside CrossOver, which is sold separately.

Is the Express edition time-limited?

No. dbForge Studio for Oracle Express is free with basic features and no time limit. The 30-day trial is for the paid editions.

What happens when my subscription ends?

A dbForge Studio for Oracle subscription becomes inaccessible when the period ends, until you renew. A perpetual license keeps working with all its features; renewing it only brings new versions and support.

Can I use dbForge Studio for Oracle with a 32-bit Oracle client?

Yes. On 64-bit Windows, the installer can add a 32-bit version of dbForge Studio for Oracle alongside the 64-bit one; it can't be installed on its own.

Can I get a refund?

Yes. Devart refunds dbForge Studio for Oracle within 30 days of purchase for annual subscriptions and perpetual licenses.

System Requirements

  • Windows 7, 8, 8.1, 10 or 11, or Windows Server 2008, 2012, 2016, 2019, 2022 or 2025
  • .NET Framework 4.7.2 or later
  • macOS or Linux (Ubuntu, Debian, Fedora, RHEL): CodeWeavers CrossOver
  • Oracle 8i to 26ai, Oracle Cloud, RAC, Amazon RDS
  • About 136 MB for the installer download

Conclusion

dbForge Studio for Oracle is a strong buy for Windows-based Oracle developers and DBAs who deploy schema changes or build reports: Professional's compare-and-sync tools and command-line automation are the reason to pay $329.95 a year, and the PL/SQL editor and debugger make the daily work faster. The main reason not to buy is that Oracle SQL Developer is free and good enough for querying, and the Studio doesn't run natively on a Mac. Use the 30-day trial on a real deployment; if the comparison saves you one hand-written ALTER script, you'll know.

Download Free TrialBuy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.

Related Videos
Best Oracle Report Builder Alternative: Create Reports Easily with dbForge Studio
Best Oracle Report Builder Alternative: Create Reports Easily with dbForge Studio

Video Length: 04:10
Uploaded By: Devart (10/7/2021)
View Count: 1,231

How to Install dbForge Studio for Oracle on Linux
How to Install dbForge Studio for Oracle on Linux

Video Length: 06:32
Uploaded By: Devart (5/23/2023)
View Count: 459

How to import and export data in Oracle [Without Coding!]
How to import and export data in Oracle [Without Coding!]

Video Length: 07:41
Uploaded By: Devart (1/25/2022)
View Count: 3,435

How to edit Oracle data using #dbForge Studio for Oracle
How to edit Oracle data using #dbForge Studio for Oracle

Video Length: 03:17
Uploaded By: Devart (2/13/2014)
View Count: 1,876

How to Compare and Synchronize Oracle Database Schemas using dbForge Studio for Oracle
How to Compare and Synchronize Oracle Database Schemas using dbForge Studio for Oracle

Video Length: 03:17
Uploaded By: Devart (6/7/2021)
View Count: 1,075

How to compare two Oracle schemas using dbForge Studio for Oracle?
How to compare two Oracle schemas using dbForge Studio for Oracle?

Video Length: 02:44
Uploaded By: Devart (2/13/2014)
View Count: 1,220

dbForge Studio for Oracle Tutorial
dbForge Studio for Oracle Tutorial

Video Length: 01:17
Uploaded By: Devart (11/25/2013)
View Count: 13,411

Copyright © 2026, Ivertech. All rights reserved.