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