PL/SQL Developer Lanzamientos

Allround AutomationsIDE
Versión 17.0 (25 ago 2026)(22)

Descubre las novedades en cada versión, con detalles de funciones, mejoras y problemas resueltos.

ene
feb
mar
abr
may
jun
jul
ago
sept
oct
nov
dic
PL/SQL Developer v17.0Versión principal25 ago 2026
Funciones
  • Redesigned Debugger:
    • The debugger has been redesigned and now automatically displays all local and global variables.
    • If you select a different stack frame, the variable list will be updated automatically.
    • Compound variables like records and object instances can be expanded in the variable list.
    • When debugging member functions or procedures, the Self variable will be available in the variable list.
    • When debugging a row level trigger, the Old and New variables will be available in the variable list.
    • Global Variables are available when debugging a package function or procedure.
    • The call stack and variable list can be placed at the right (default), left, or bottom of the Test Window.
  • Added support for DBMS_DEBUG_JDWP:
    • The debugger now supports both the DBMS_DEBUG and DBMS_DEBUG_JDWP system. You can select your preferred debug system in the preferences, which can be overruled in a Test Window when starting the debugger.
    • The DBMS_DEBUG_JDWP system has the following advantages over the DBMS_DEBUG system:
      • It allows for JAVA SOURCE debugging.
      • It can display collections of a compound data type.
      • It will display date values with time fraction if present, regardless of NLS_DATE_FORMAT.
    • Because the DBMS_DEBUG_JDWP system is more complex to setup, a new JDWP Configuration Wizard has been added.
    • The JDWP Configuration Wizard allows you to quickly configure, test, and fix the listener port, object and system privileges, and firewall rules necessary for DBMS_DEBUG_JDWP usage.
  • Added support for Github Copilot:
    • The AI Assistant now supports GitHub Copilot both for free and paid subscriptions through the Copilot CLI interface. This interface can be installed and configured in a few easy steps. After installation, you can enable the GitHub Copilot CLI system and you are ready to go.
  • Support added for Oracle 23ai MLE Modules:
    • PL/SQL Developer now supports MLE (Multilingual Engine) Modules in the Program Window for editing and compilation, and in a new 'MLE Modules' folder in the Object Browser.
    • MLE Modules are also supported in the Find Database Objects tool, Compile Invalid Objects tool, Export User Objects tool, and the Compare User Objects tool. In the File Extension preferences you can define a default file extension for MLE Modules.
  • Added support for Oracle 23ai Domains:
    • A 'Domains' folder has been added to the Object Browser.
    • The Domain popup menu in the Object Browser includes a View, Edit, Drop, and Properties function.
    • A File > New > Domain menu item has been added with a corresponding template.
    • The Table Definition Editor now supports domain columns.
    • DDL for Tables now includes domain column definitions.
  • Added support for Oracle 23ai Annotations:
    • Annotations added to the Table Definition Editor at the column and table level.
    • DDL for Tables and Views now includes annotations.
    • Annotations and Annotation Usage have been added to the Object Browser.
  • Added support for Oracle 26ai Assertions:
    • An 'Assertions' folder has been added to the Object Browser.
    • The Assertion popup menu in the Object Browser includes a View, Edit, Drop, and Properties function.
    • A File > New > Assertion menu item has been added with a corresponding template.
  • Added Excel Importer:
    • The new Excel Importer can import data directly from an Excel file, without the need for an ODBC driver like in previous PL/SQL Developer versions. On the 'Data from Excel' page you can select the sheet from the Excel file that you want to import, as well as the header line and the first and last line that you want to import.
    • Instead of selecting an Excel file you can also copy a selection in the Excel application and use the 'Paste data' button.
    • On the 'Data to Oracle' page you can map the Excel data to a table and column, exactly as in the Text Importer and ODBC Importer.
  • AI Assistant Enhancements:
    • The default AI System models have been updated to the latest versions.
    • A 'Keep Selection' output option has been added to the AI Function definition. When enabled, the generated code in the editor is automatically selected afterwards.
    • A new Test button for AI Systems allows you to quickly test the AI System configuration.
    • The AI Usage report has a new 'By Month' grouping option.
    • The AI Usage report has a new sort order button.
    • AI System and AI Functions can now be copied and pasted in text format.
    • AI Configuration grids now have an alternate row color for better readability.
    • The AI Assistant function menu is now directly available for an object from the Object Browser for informative functions like 'Explain', 'Review', and 'Ask Question'. The AI function will take the source of the selected object as input.
    • The AI Dialog functions now have a 'Save as SQL' button.
    • The Answer pane of the AI Dialog functions now have a popup menu to copy code or to open the code in a Program Window or SQL Window.
    • If an AI Function result is truncated or only comments, the AI Assistant will now display a warning when replacing selected code.
  • SQL Window Enhancements:
    • Large number fields will now be displayed with full Oracle precision.
    • Function keys have been added for 'Copy Header' and 'Copy As Expression List'.
    • You can now paste multi-line text into the Column Filter of the result set toolbar.
    • If execution time is more than 100 seconds, it will be displayed as hh:mm:ss on the status bar.
    • You can now use &Count in the 'TAB=Name' comment directive to show the rows fetched or affected in the tab caption.
    • The updating table is now determined from the rowid instead of order of the table list of a select statement.
    • Disabling substitution variables now also disables bind variables.
  • Command Window Enhancements:
    • Large number fields will now be displayed with full Oracle precision.
    • The SET FEEDBACK command now supports the ONLY and SQL_ID clauses.
    • Unsupported SET commands (e.g. SET NEWPAGE) will no longer display an error when executed from a batch script.
  • Programming Code Ligature support added:
    • The Editor will now display programming code ligatures when using a font that supports them (e.g. 'Cascadia Code', 'Fira Code', or 'JetBrains Mono'). Programming code ligatures combine multiple characters (like != or ->) into a single glyph, or improves the alignment of these characters. This makes the code more readable.
    • The ligatures take up the exact same space as the standard characters, so that alignment is preserved. In the font selector you can filter on ligature support, so that you can quickly make a selection. Programming code ligature support is enabled by default, but can be disabled in the preferences if necessary.
  • Editor Enhancements:
    • Many performance improvements for large sources (loading, navigating, editing, copying, parsing).
    • Hyperlink Navigation with Right-Click on a Table or View will open a SQL Window with query results.
    • The Find & Replace dialog now has a Mute button to suppress sound notifications.
    • A new 'Open in VS Code' item has been added to the popup menu.
    • The filter of the Recall Statement function will now immediately be applied as you type.
    • The Code Assistant now also lists declarations from the package specification when editing a package body.
  • Large Data Editor Enhancements:
    • Added the ability to format and parse HTML.
    • A new 'Auto Format' option has been added to the popup menu, to automatically format XML, HTML or JSON.
    • Format autodetection has been improved.
  • PDF Viewer Enhancements:
    • A new 'Fit Width' button has been added to zoom in for improved readability.
    • The performance has been improved for very large documents like some Oracle manuals.
  • External Tool Enhancements:
    • A new 'line' and 'column' parameter has been added to pass the current editor position to an external tool.
    • A new 'Editor Text Only' option has been added, to pass the only the text of the current editor, instead of the complete file.
    • New 'Run Hidden' and 'Run Minimized' options have been added to hide or minimize the external tool application window.
  • Other Enhancements:
    • Copying a grid to the clipboard now also includes HTML format, for pasting in applications that support HTML.
    • New 'Application Title Format' and 'Application Title Alignment' preferences have been added.
    • The Application Title format can now be customized to include connection information, window information, workset information, and project information. The Application Title can additionally be centered or left-aligned.
    • Ctrl-C from Object Browser, File Browser, Connection List, and Template List now copies the selected items to the clipboard.
    • A new Oracle > Options preference: 'Use FORCE option for View DDL' has been added. It can be set to 'Only for Exports', 'Always', or 'Never'.
    • On the window tab bar, you can now close all windows to left or right of the selected tab.
    • When closing multiple windows with changes, you now have a 'Same for all Windows' option.
    • Preferences for File Extensions now support * and ? wildcards for the list of 'Other' extensions.
    • When a file is opened, the status bar will now show the version control status, including the Git branch.
    • The Uppercase and Lowercase function keys now also work in editable grids.
    • PL/SQL Beautifier now shows a status message when finished.
    • File > Close All will now ask for confirmation if a Workset is open, to prevent that the Workset is inadvertently cleared.
    • New User Interface > Options preference: 'Show database name in window titles' (Default = On).
    • The preference 'User Interface > Use multi-row tabs' now also applies to the window tabs bar.
    • Program Window Code Hierarchy buttons now have a popup hint with the first line of the code.
    • New Files > Format preference: 'Export to Excel with alternate row colors' (Default = On).
    • New translations: Ukrainian, Korean, Polish, and Arabic.
    • Preference Export and Import functions are refined and improved.
Correcciones
  • Performance & stability improvements.
  • The warning 'ORA-28098, Profile limits PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME are not unlimited, password will expire within <n> days' was not handled properly.
  • Changing a SQL Window connection with one or more LOB columns in a result set could cause an error if the 'Fetch CLOBs and BLOBs on demand' preference was enabled.
  • Standard Queries and Standard Tests could not always be opened if the name includes non-ANSI characters.
  • The Large Data Editor did not have enough space in gutter for line numbers.
  • The Large Data Editor did not update the search location when the cursor location is changed.
  • Tools and Documents custom images did not always have the correct size.
  • When selectin text in a result grid, an incorrect 'not all records fetched' warning could be displayed.
  • Exported Excel files with an alternate row color were not always properly readable in Dark mode.
  • Test Window HTP Output page did not show UTF8 characters correctly.
  • The Explain Plan Window would not always refresh the contents of the HTML page.
  • Worksets could not be opened again when the desktop parameter was specified.
  • The 'Copy to Excel' function could cause errors when large binary data was included.
  • The AI Usage Report could be slow.
  • Some buttons did not have a consistent style.
  • Opening a SQL File where some lines are terminated with just CL or LF characters could cause selection errors.
  • The size of the window icons in the window tab bar was too small.
  • Object attribute values of type BINARY_FLOAT and BINARY_DOUBLE could not be displayed.
  • Pasting text in the Editor with tabs did not always convert the tabs correctly.
  • Filtered templates did not always have the correct icon.
  • Filtered templates did not always have the appropriate popup menu items enabled.
  • Explain Plan did not work for a read-only connection.
  • Using reserved words in a quoted identifier name could cause a PL/SQL beautifier error.
  • AI Assistant dictionary queries did not comply with 'Use DBA views if available' preference.
  • Java Source compilation errors were not always displayed correctly.
  • AI Functions did not work from a custom toolbar.
  • PL/SQL Beautifier could not always process Q'<strings>’ and comments with quotes within item lists.
  • PL/SQL Beautifier did not always work with some case expressions.
  • Ctrl-Backspace did not work correctly for a column selection in the Editor.
  • Preferences could be lost in case of a system or application crash.
  • Window status messages were not cleared when the connection is changed.
  • AI prompt variable {FILE [NAME=]<filename>} did not work if 'NAME=' was specified.
  • The Code Assistant would list invisible columns for %ROWTYPE variables.
  • The 'Queue tables' folder contents under the user objects in the Object Browser were incorrect.
  • The PL/SQL Beautifier would place an ELSE after an OPEN statement on the same line.
  • Roll up windows would not always roll up to the correct height.
  • The To-Do List 'Edit' popup menu item did not work if the double-click action preference was set to 'Go to item'.
  • The To-Do List was not always up to date.
  • The To-Do List 'Go To' function did not handle Program Window split editing correctly.
  • The Debugger now has an Append to clipboard function for variable values.
  • The Large Data Editor HTML page could display dark text on a dark background.
  • Explain Plan HTML, XML and Text tabs could be empty on some Oracle Client / Server version combinations.
  • Explain Plan did not work if the username was more than 30 characters.
  • When copying preferences/settings from a previous version, file and directory timestamps were not preserved.
  • Changing a SQL Window to a Program Window did not synchronize the Code Contents correctly.
  • Word marking did not work if the word was immediately followed by a colon (e.g. varname:=3).
  • The Large Data Editor would display an error message when auto-formatting invalid XML.
  • Clipboard History could be empty until the first copy operation.
  • Accelerator keys in menus would not always be visible.
  • The PL/SQL Developer icon would not always be visible on the taskbar.
  • The sort order arrow indicator did not conform to standards.
  • Opening a diagram when not connected could lead to an error.
  • Fetching sources from the database could be slow on networks with high latency.
  • When setting the NoLoadDesktop parameter, the desktop would still get loaded when closing a project.
  • Using Claude Sonnet 5 for the AI Assistant could cause an Access Violation.