PL/SQL Developer 11.0.4 updated
Released: Sep 1, 2015
Updates in this release
Updates in 11.0.4
Enhancements
- Performance and stability improvements
- Export to XLSX did remove leading and trailing spaces from data
- Find and Replace would keep incrementing number on status line when nothing was replaced
- When using date/time selector in the SQL result grid, PL/SQL Developer would lose focus
- The file format encoding preference "Always as UTF8" did not work for the Program Window
- Crash recovery saved per InstanceName parameter value
- Shortcut key assigned to object functions could insert a character in editor
- SQL Window "totals" comment directive did not use "sum" as the default function
- Ctrl-C did not work in HTML viewers when "Use Internal HTML viewer" preference was not set
- Code Assistant Multi-Select now also available for a table alias in a select list
- Crash recovery could lead to a filename error when using a multi monitor setup
- Double-clicking on a packaged function or procedure could lead to a "Function not valid" error message
- Logging off a session did not update the transaction status in the Window List
- Creating new scheduler objects with timestamps could lead to "Could not convert variant" error message
-
Command Window addition for batch locking/unlocking of report files:
- REPORT LOCKFORALL <path> <password> [R]
- REPORT LOCKFOROTHERS <path> <password> [R]
- REPORT UNLOCK <path> <password> [R]
- REPORT LIST <path> [R]
For the path you can use wildcards or directories.
Add the R parameter for recursive directory scans.
- Report Window option "Locked for other users" always asked for password
- PL/SQL Parser did not process double quoted identifiers with quotes and comments correctly
- Code Assistant did not work for aliases for table names in double quotes
- Right-click on a quoted "OWNER"."OBJECT" would not show the object functions in the popup menu
- Object popup menu item "Browse" will now display the Object Browser if necessary
- Tnsnames.ora file with alias list on multiple lines was not parsed correctly
- Editor with long lines and highlight edit line enabled would not draw text correctly
- Using Alt-Down to get a list in the SQL Window result grid could insert a character
- Connection indicator added to the Object Browser for main connection
- Object Browser filter text now also works for user-defined query-based folders
- Viewing job classes on Oracle12c could lead to "ORA-01036: illegal variable name/number"
- PL/SQL Beautifier did not format FORALL/MERGE loop correctly
- Test Window now processes trailing slash of a PL/SQL Block
- Fixed visual scaling issues on high DPI screens on Windows 8 and Windows 10
- Comments are now preverved when using QBE in the SQL Window
- Undo/Redo did not work correctly after using QBE in the SQL Window
- Changing a Program Window connection would not always apply compiler preferences
- Test Manager window title would be cleared when logging off
- Compare Table Data tool now ignores virtual columns
- You can now use comma's in substitution variable lists and checkboxes by specifying 2 comma's:
&<name="Exception?" checkbox="raise_application_eror(-20000,, '[#]'), null">
- Substitution variable checkbox unchecked value now defaults to empty when 1 value is given
- DDL for indexes on virtual columns would specify the column expression instead of the column name
- Fixed Session > Set Main Connection menu icon transparency issue
- Using the Search Next function in a macro not always work correctly