PL/SQL Developer for Windows

PL/SQL Developer is an IDE focused on Oracle Database stored program units. It provides a Unicode PL/SQL editor with syntax highlighting, Code Assistant, refactoring, a beautifier, and navigation aids. Core tools include a SQL Window, a Command Window, an Object Browser, projects, diagrams, and reports. The multi-threaded workspace lets you continue working during executions.

Oracle stored-code IDE

Integrated debugger supports stepping, breakpoints, and variable inspection. Quality tools cover unit tests through a Test Manager and performance analysis via a Profiler and SQL statistics. Recent releases add an AI Assistant for code generation and review. Editors expose Explain Plan for selected SQL.

Editing, debugging, tooling

The PL/SQL Developer editor targets PL/SQL and SQL, with syntax highlighting, Code Assistant, formatting, folding, hyperlinks, and macros. The SQL Window executes statements, showing editable results in a grid with Query-By-Example. The Command Window aligns with SQL*Plus. The Object Browser displays definitions, dependencies, and actions. Diagrams depict objects/relations. Projects group files, objects, and notes. Built-in reports query data and the data dictionary.

A debugger runs stored program units without edits, offering features such as Step In, Step Over, Step Out, Run Until Exception, breakpoints, call stack, and watches. The Test Manager defines test sets (scripts, variables, expected outputs) and can launch the debugger on failure. A Profiler records timing per executed line; statistics views collect resource metrics. Editors expose Explain Plan. Tools manage DBMS Scheduler jobs, compare user objects, and generate DDL exports.

Integration and automation include built-in version control for Git and Subversion, supporting commit and history directly from editors via file-level operations. An AI Assistant connects to external AI systems via an API key and exposes custom functions for generating, modifying, or explaining SQL and PL/SQL. However, the AI Assistant requires external model credentials. The multi-threaded workspace keeps editors responsive.

Build and deploy

PL/SQL Developer presents an Oracle-focused IDE for stored code with editing, SQL and script execution, debugging, unit testing, profiling, statistics, and plan inspection. Workspace tools include projects, diagrams, reports, object browsing, and export/compare utilities. Integration covers Git/Subversion at the file level and an AI Assistant configured through external providers. It focuses on PL/SQL and database object operations, intentionally omitting a plug-in marketplace and a built-in terminal.

• Performance and stability improvements