Features

• Improved performance and stability.
• Export User Objects now takes 'UTF8/ANSI' encoding preference into account.
• Save text from large data editor now takes 'UTF8/ANSI' encoding preference into account.
• Dragging and dropping a shortcut will now open the shortcut target file.
• Clicking on the 'To-Do List' button in the Project Window will now directly take you to the To-Do Items.

Fixes

• SELECT FOR UPDATE statements in the SQL Window could be rolled back if there were additional spaces or comments between FOR and UPDATE.
• Oracle23c Boolean field datatypes were displayed as boolean(1).
• Oracle23c Boolean field data was displayed as T/F on an Oracle23c Client, instead of 1/0 on older clients.
• Oracle23c Boolean column data could not be exported with the "Export Tables" tool.
• Objects with Oracle23c Boolean attributes could not be accessed.
• Test Window would interpret bind variables within double quotes.
• Drag & Drop did not work correctly in the Connection List: only windows can now be moved to another connection.
• When using an external difference viewer, Unicode characters would be converted to question marks.
• Session Window detail queries did not support WITH FUNCTION statements.
• Performing a Find with an error in a regular expression could cause a long delay.
• Wrapped text in result grid cells could be visually truncated.
• Command Window would not spool line comments.
• A comma in a password would not work correctly when the PL/SQL Developer desktop was reloaded.
• Some Test Manager Edit menu items would incorrectly be enabled.
• Export to Clipboard would not always work correctly for Unicode.
• Opening a database source with compilation errors would not allow you to navigate to an error.

Features

• Improved performance and stability.
• Added Oracle 21c JSON column data type support to the SQL Window and Large Data Editor.
• Command Window feedback has been updated with the latest Oracle 21c SQL commands.
• Export Zip format now automatically switches to 64-bit mode.
• System generated indexes are now omitted for compare operations.
• Improved behavior when switching between Multiple and Single Document Interface.

Fixes

• Large Data Editor External tool did not work correctly if the %1 parameter was omitted and the temp path includes spaces.
• Oracle21c JSON column data type was incorrectly presented with size as JSON(8200).
• Oracle21c JSON parameter data type was incorrectly presented as “Unknown type 119”.
• The plsqldoc Plug-in function “View Documentation” could cause an Access Violation.
• Oracle HTML Manuals function would sometimes navigate to the top of the page instead of the context topic.
• Creating a new Workset based on a previous Workset would incorrectly allow multi-select.
• Quoted identifiers that are too long were not marked as such.
• Adding an SQL Window to a Project could add the table of the select statement instead of the SQL Window file.
• SQL Window and Test Window Statistics sorting would change after each run.
• Compare User Objects / Compare Table Data: Cancelling the Target Session logon dialog would disconnect previous target session without displaying “not connected”.
• Command Window would not always show execute status correctly when executing external files.
• Command Window “set sqlblanklines” did not always work properly.
• Command Window Export Tables command in “SQL Inserts” mode did not always pass the “drop” parameter.
• Command Window Export Tables command in “PL/SQL Developer” mode did not always pass the “where” parameter.
• Saving the DBMS Output text in a SQL Window or Test Window would remove trailing spaces.
• Editor bookmarks could be displayed at an incorrect horizontal position in the editor gutter.
• Code Assistant did not always work for select alias for “insert into … (select …)” statements.
• Printing CLOB text from Large Data Editor could give blank pages in dark mode.
• A maximized window would not always keep focus.
• The “Arrange” menu items are now always enabled, and will switch to SDI if necessary.

Features

• Improved stability.
• Improved performance when using Single Document Interface.
• Improved Object Browser and File Browser performance when expanding items.
• Added new styles: Windows 11 Light & Dark, Windows 11 Polar Light & Dark, Copper Light & Dark.
• The new Windows 11 Light & Dark styles are now used by default on Microsoft Windows 11.
• Report "Style Library File" option has been added, which adds support for CSS files.
• Improved button image colors for SQL Window fetch next page, last page and post changes.
• Search Bar performance has been optimized for searches with many hits.

Fixes

• Report Window print did not work for the Edge Browser interface.
• Maximizing or restoring the Find Database Objects window would raise a "Component already exists" error.
• Starting PL/SQL Developer by double-clicking a source file did not always open the file.
• Opening the Find tool with selected editor text would remove leading and trailing spaces from the default find text.
• The Command Window resulting from the DBMS_Metadata > DDL function used the main connection instead of the source object connection.
• Reload and Revert would not restore bookmarks.
• Macro menu items (and Tools, Reports, etc.) in toolbar would not be restored after program start.
• Docked Search list results would not jump to selected item.
• Search list would not always be updated when a window was closed.
• Code Assistant scrollbar could not be dragged.
• SQL Window result set paste with a selected row could result in column data mismatches.
• Session Window would not stop auto refreshing in case of error.
• SQL Window Ctrl-F8 (execute current statement) would cause an Access Violation if PL/SQL Developer is not connected.
• Fixed some multi-monitor High DPI issues.

Features

• Stability improvements.
• Editor Object Popup sub menu now has a corresponding object image.
• Database Link Definition Editor for 'current user' now has the password field disabled.
• Window connection menu now has a 'Read Only' item to view or change the read only mode of the window session.
• A 'Read Only' window connection is now displayed with a lock icon.
• SQL Window 'Edit data' button now shows an error message if the connection is read only.
• Explain Plan function for update and delete statements now automatically removes a RETURNING clause.
• Explain Plan Window Editor now has highlighting for parentheses and DML items.
• Parameter 'NoAppShadow' added to suppress the main application window shadow.
• OCI Library preference now has a file selector.
• Added Report Window Dark Styles.
• Active Query Builder and plsqldoc plug-ins updated to the new PL/SQL Developer 15.0 style.

Fixes

• Difference Viewer options button only worked with right-click.
• Editor Object Popup submenu “Standard queries” was empty.
• Generating a Test Script did not handle “Procedure XXXX within package YYYYYY does not exist” exceptions.
• Generating a Test Script for a packaged procedure/function did not include the procedure/function name in the window title.
• Drag & drop did not always work in the Window List.
• Table Definition Editor did not support invisible property for virtual columns.
• Search List dockable tool in unpinned mode could cause errors.
• Changing the Read Only property of a Connection definition did not update the currently opened windows for that connection.
• Shift-Click in a result grid cell did not mark a selection.
• Program Window compilation could cause a flash in the editor.
• With an External Difference Viewer defined, the “Reload and discard current modifications?” feature did not work properly.
• Program Window Code Contents and PL/SQL Beautifier could not process quoted identifiers without separating blanks (e.g. procedure”Init”is…).
• Fixed Key configuration grammar error (spec && body).
• Export Key Configuration in the preferences did not work.
• Popup menu items in Plug-Ins could be invisible.
• File dialogs in Plug-Ins were not displayed correctly.
• Recall Statement search filter did not work when PL/SQL Developer was not connected.
• New Plug-Ins with svg images would not show these in popup menu.
• To-Do List did not immediately show items when a file was opened.
• Preference name was not displayed correctly when using international characters.
• Connection definition property fields could be incorrectly disabled.
• Some Plug-Ins had large images in popup menus.
• DBMS Scheduler did not have the correct icon for Schedules.
• SQL Window “Refresh result set” function would cause a flash.
• Workset Manager Filter field did not always have a hint.

Features

Dark and Light Mode styles

• You can now select a visual style for PL/SQL Developer, with redesigned line style graphics. You can choose from 17 light mode styles and 19 dark mode styles.
• In the preferences you can choose which style to use when Microsoft Windows is in light mode, and which style to use when Windows is in dark mode. By default the “Sky” style will be used for Windows light mode, and the “Glow” style will be used for Windows dark mode. You can also revert to the standard Windows style.

Read-Only Connections

• You can now define connections as read-only, so that you cannot make any modifications to the table data or object definitions. Any attempt to make such a modification will lead to an error message.
• There are two methods to define connections as read-only. The first is to set the corresponding property in the Connection definition.
• You can also specify read-only connections as a command-line parameter or in the Params.ini file.

Editor enhancements

• A macro can now be repeated by using the Repeat play function. You can specify the number of repeats, or let the macro run to the end of the file.
• A new Code Assistant preference has been added: “Place comma before item when inserting items on multiple lines”.
• A new function key “Comment/Uncomment Line” has been added, which is assigned to Ctrl+’-‘ by default. This function adds double hyphens to comment a line, or will remove them if already present.
• The status line now shows the selection length next to the cursor location (line:col [length]).

Bookmark enhancements

• If the Bookmark List is docked horizontally, it will be displayed as a menu.
• You can now change the display name of a Bookmark. By default the display name is the text of the source line of the Bookmark.
• A Bookmark now stores and restores both the editor cursor position and editor top line.
• Right-clicking on a Bookmark now shows a popup menu with Bookmark functions Goto, Name, Delete, and Delete all.
• The Bookmark List now includes window icons.

SQL Window enhancements

• You can now pin result sets. Normally when you execute a SQL script, all previously fetched results will be cleared. To preserve a result set after subsequent execution, you can click on the tab while holding down the Shift key, or by right-clicking on the tab or on the result set and selecting Pinned from the popup menu. The result set will now be pinned, as indicated by the pin icon on the tab.
• Changes made to the result set grid can now be viewed as SQL text in a SQL Window, Command Window, or copied to the clipboard.
• Graphs will now automatically refresh when you re-execute the query in the SQL Window, or when you update the data.
• You can now export column data to a file per record. After selecting the Column to files menu item from the Export results submenu, you can select the column to export, the root output directory, and an expression for the subdirectory and filename that is unique for each row.
• If Microsoft Excel is not installed and you use the Copy to Excel function, the resulting file will now be displayed in the Windows Explorer.
• DBMS Output tab page now indicates when output has been written.

Large Data Editor Enhancements

• JSON text can now be displayed with syntax highlighting and folding.
• JSON text can now be parsed and formatted.
• XML is now only automatically formatted if it is unformatted.
• Buttons have been added to edit the data, to post the data to the database, and to go to the next or previous record in the result set.

Automatic statistics enhancements

• You can now sort on a column by clicking on a sort button on the column header.
• You can now filter the statistics by name.
• Statistic values are now displayed with a decimal group separator.
• The grid position is now preserved after re-executing a script.

DBMS Scheduler enhancements

• Credentials can be now be created, modified and dropped.
• File Watchers can now be created, modified and dropped.
• Credential, file watcher and destination can now be defined for a job.
• Job view/edit performance improvement - Logs and Run details are now fetched on demand and limited to 100 most recent rows.

Workset enhancements

• Clicking on the Workset button now opens the Workset selector. Clicking in the Workset button arrow shows the most recently user worksets.
• The Workset manager and Workset selector now show the last used date.
• You can now filter Worksets by name in the Workset manager and Workset selector.
• You can now sort Worksets by name or date in the Workset manager and Workset selector.
• When opening a Workset, you will now be warned if a database source was changed since it was used to the workset.
• If a file was moved since it was last used in a workset, you can now select the new file location when opening the Workset.

Search List enhancements

• If the Search List is docked horizontally, it will now be displayed as a menu.
• The Search List now includes window icons and line numbers.

Window List enhancements

• The Window List can now be sorted by window type and/or name by right-clicking on the list and selecting a sort option. The list will remain sorted until you deselect the sort option or until you explicitly move a window in the list.
• Mouse middle-clicking on the Window List will now close the window.

Compare User Objects Enhancements

• The output now includes “set sqlblanklines on” + “set define off” commands for improved SQL*Plus compatibility.
• Trigger enabled/disabled status is now also compared.
• Identity column sequences, replication packages, and materialized view log tables are now excluded.
• Pressing apply more than once will skip differences that were previously successfully applied.

SDI enhancements

• SDI (Single Document Interface) mode is now automatically enabled when you maximize a window.
• SDI preferences have been added for the position of the tab row (top, bottom, left, right) and for a multi/single line tab row.
• Mouse middle-clicking on a tab will now close the window.
• The tab row now includes a button to switch to MDI (Multiple Document Interface) mode.

Other enhancements

• PL/SQL Developer can now be installed for the current user only without administrator privileges, or for all users.
• The Code Contents and PL/SQL Beautifier now support Oracle 21c loop enhancements.
• Code Assistant, Export functions, and Compare functions no longer include replication packages, materialized view log tables, and identity column sequences.
• Preference has been added for Oracle environment variables, such as NLS_LANG, NLS_DATE_FORMAT, and so on.
• The HTML viewer can now use the Microsoft Edge engine for improved performance and compatibility.
• Added a new To-Do List preference: “Double-click action”.
• The DefaultPrefPath parameter now supports environment variables.
• Preference has been added to reduce Icon sizes for the ribbon, trees, toolbars, and so on.
• Connections and connection folders can now be moved up in the hierarchy.
• When opening a Crash Recovery, you will now be warned if a database source was changed since the crash.
• When using a main menu instead of a ribbon, the Workset items are now placed in a Workset submenu.
• Test Window SQL output can now also be copied to Excel in XLSX format.
• Function key “Grid: Cell Button” now also works for list boxes.
• The Program Window will now preserve the editor positions when reloading a source.
• File Browser now has a sort option in the popup menu.
• SQL Window and Command Window now underlines whole word in case of errors.
• Compiler preferences warning list has been updated for the latest Oracle versions.
• Diagram Window Line Labels setting is now stored with default line settings.
• Command Window BEAUTIFY command for package and type database objects now processes both the specification and body.
• When right-clicking on an object name in an editor, object functions are now placed in a submenu in the editor popup (Parameter “InlineObjectMenu” to override).
• When notified of file or object changes, the Difference Viewer now has a [Reload Window] button.

Fixes

• Unicode smileys and dingbats were not converted correctly.
• Crash Recovery and Workset could lead to an access violation when the recovery or workset file was not found.
• An include file (ifile) with parentheses in tnsnames.ora file would not be processed.
• Unicode field names or SQL text would be corrupted when a opening Text Importer Definition.
• Connection Definition did not allow for an externally identified [schemauser] proxy user.
• Automatic Statistics could be disabled when using multiple connections and one connection does not have select privileges on the statistics views.
• All grids now have scrollbar thumb tracking (e.g. statistics grid).
• Text Search excluding comments could find text in comments for single character searches.
• Unicode characters could be lost when changing/copying a window type when the “Save with BOM” preference was disabled.
• File Drag & Drop from a local network drive for a OneDrive directory would incorrectly see the file as a directory.
• Match highlighting did not work correctly if the source contained commas or parentheses within double quotes.
• The SQL Window Column Filter field could be cleared when editing the text.
• The Test Manager Definition List was not always synchronized.
• A macro with a “Comment Line” did not work correctly.
• Incorrect “TO_DATE without format hint” for date expressions with parentheses.
• Executing multiple reports simultaneously could lead to a “cannot create file” error.
• Session Window HTML columns would always be displayed in a window with a “SQL Monitoring Report” title.
• Text Importer could cause an “ORA-00936: missing expression” when using the “Overwrite duplicates” option.
• The Connection indicator color did not work for SYSDBA connections.
• Table Edit/Query Data did not add quotes for lowercase table names.
• XML formatting in the Large Data Editor would remove the encoding clause from the XML declaration.
• Table Rename did not work for mixed case table names.
• Hyperlink navigation did not work with quoted identifiers.
• Ctrl-Insert did not work in the Object Browser.
• Help > Support Info no longer displays the password of the userid parameter value.
• Mixed case usernames were not passed correctly to user-defined tools.
• Mixed case usernames were not processed correctly when restoring the desktop.
• Function keys “Window: Auto refresh”, “Window: Change connection”, and “Window: Pin connection” did not work in all window types.
• Window “Change to” and “Copy to” did not preserve the pinned connection status.
• Delete Unindent did not always work correctly.
• Find “From Cursor” did not always work correctly.
• Windows 11 Alt-Tab application switching did not work properly.
• SQL Window Column Totals could cause an “unknown column” error after re-execution for column names with a comma.
• Export User Objects did not conform to the file encoding preferences (ANSI/UTF8/BOM).
• PL/SQL Beautifier did format multi-line q’strings correctly when not using brackets and the 2nd character is a quote (e.g. q’*’…LF…’*’).
• Logon error message box did not have a copy popup menu (and icon).
• Crash Recovery did not always work after shutting down Windows with unsaved changes.
• Using the editor find function with excluded strings or comments, did not always work correctly.
• Numbers were not always highlighted correctly in the editor.
• Editor column editing with a column width of 0 did not work correctly.