PL/SQL Developer - News

• Code Assistant performance improvement for table/view column lists
• Registry tab page if the Support Info screen did not display DWORD values correctly
• A duplicated user did not show role privileges in SQL statements when no new user name was provided
• Object Browser double-click action and drag & drop action could not be defined for database link type
• Subprogram declaration popup could be truncated if it included comments
• Dates < 1901 were not copied correctly to Excel 2007 and 2010
• Selecting a previously logged off connection would not always log that connection on again
• SQL Window and Test Window did not display SYS.XMLTYPE attributes of an object field
• Typing a target schema name in the Compare Table Data tool could cause an "Invalid Typecast" error
• Compare User Objects and Compare User Data did not show the source owner in the generated script comments
• Compile Invalid Objects tool could raise "Null password given" error in single connection mode
• Auto Refresh for SQL Window in single record view could steal the focus from the top window
• Command Window would not allow cursor left beyond the prompt size

• Modifications for German, French, Spanish and Chinese language packs
• Compile Invalid Objects would show no invalid objects when session was killed
• Report Window could not break on field names with international characters
• Pasting a record in the SQL Window result grid could lead to a "Column index -1 out of range" error
• Compare User Objects did not prefix table with target schema when dropping constraints
• Table DDL could be incorrect for object columns when not connected as owner
• Date fields were not always exported correctly to xlsx when am/pm date format was used
• Editor and Grid did not allow Alt-0128 to insert Euro sign
• Initial connection dialog did not always show last username and database
• Define Connections menu added in Tools menu
• Standard Query popup menu did not work for project items

• NLS_LANG and TNS_ADMIN command-line parameters added
• PDF export from Report did not give correct result for screen DPI other than 100%
• Directory preferences now support environment variables
• When using a language pack the default templates were not always found
• Export to Excel as xlsx would not handle AM/PM correctly
• Improved Excel xlsx export for UTF8 characters
• Cursor position in status bar would not always show correct character position with selections
• Pasting data in a grid with a selected column could start on an incorrect row number
• Diagram Window, Items > "Order as created" did not work correctly for added fields
• Character Set Mismatch warning will now only be displayed once for a connection
• Command Window did not interpret alternative quote delimiters
• Code Assistant on lower split editor in Program Window did not always display at the optimal location
• Text Importer and ODBC Importer now convert invalid field names to valid table column names
• Import Table in PL/SQL Developer format could lead to "ORA-01722: invalid number"
• Editor: AutoReplace function key now also works if AutoReplace preference is disabled
• Editing when disconnected could implicitly connect
• DBMS_Output longer than 4000 characters per line would lead to ORA-06502
• Test Window function "Start Debugger" could remain disabled in Single Connection mode
• Opening a Constraint folder could show a message with the query text
• SQL Window performance improved for inline view queries
• Added warning for "expand all" browser items
• Session > Log On could lead to "Null password" error when session is subsequently used
• A renamed Program Window would get its original name restored after saving

• SQL Window Linked Queries did not work for constraint names with Unicode characters
• Session > Log off did not always succeed for the main connection
• Session > Log off could be incorrectly disabled for the main connection
• Command Window "HOST" command did not work on Windows 7 x64
• Setting the main connection in single connection mode is now disabled if one or more windows are running
• Logon did not always work in Single Connection mode
• Logging off with an open Command Window could lead to "ORA-01005" error
• Fixed "ORA-1005 null password" error
• Performance improvement fetching Code Assistant names
• Prevent "List index out of bounds" when clicking on Window List
• Code Assistant now sorts user objects by name instead of type, name
• Code Assistant did not always work for user object lists and object method parameter lists
• Applying a filter to an Object Selection List with no matches would lead to an unusable list
• Smart Indent did not always work correctly when Smart Fill option is enabled
• Compare User Objects with NLS_LENGTH_SEMANTICS=CHAR could cause incorrect differences
• Changing the Table Definition Editor connection in "Single Session" and "Dual Session" mode did not work properly
• Object Selection List filter would accept space as delimiter
• Adding a Test Script to the Test Manager would incorrectly copy the variable value/type
• Adding a User Defined Tool before a main menu item would add multiple menu items
• Searching in Projects could lead to a "file not found" error
• Log Off in Single Connection Mode with DBMS_JOB editor open could ask for password
• Querying BFILE columns could cause ORA-22290
• When restoring windows in single connection mode, different connections could be used
• Toolbar button configuration displayed two incorrect buttons
• Automatic Statistics did not always work after changing a connection
• User Defined Object Browser Folders with object list could show incomplete contents
• Fix conversion error message for Excel export when date format is incorrect
• Object Browser Constraints root folder did not apply user selector filter
• Object Browser Constraints root folder would show constraints from recycle bin
• Reports would not always show sums on breaks
• AfterConnect.sql script was not always executed when changing a window connection
• SQL Window record number column was not scroll locked
• Using Ctrl-C in the Object Browser would not always copy the full object name

• Fixed incorrect post button status after posting & committing a CLOB value in Single Record view
• Fixed "Session Undefined" error
• Queue table DDL could specify 'ENQUEUE_TIME' instead of 'ENQ_TIME' in the sort list
• Standard Command Window variables _O_VERSION, _O_RELEASE, _USER and _CONNECT_IDENTIFIER were not always defined
• Execute button would not be enabled after logging on in Single Connection Mode
• Popup menu item "Change Window To" would always use main connection for the resulting window
• SQL Window refresh record could fail for tables with an XMLTYPE column
• Fixed "ORA-01460: unimplemented or unreasonable conversion requested" on 9.2 and earlier UTF8 databases.
• Explain Plan for update and delete statements with table alias did not convert PL/SQL variables correctly
• Command Window prompt would not be updated when selecting a connection from the list
• Debugger did not display collection items indexed with a variable
• Typing in the Debugger watch list could sometimes swap the first and second character
• Find function did not work from Support Info dialog
• SQL Window would not show information about posted changes when "Show Dictionary Info in result grid" was enabled
• SQL Window would not always interpret alternative quote delimiters correctly
• Compare User Objects could not apply changes for Views with comments
• Excel xlsx export now uses the current date/time format
• Fixed Project Groups visibility issue
• System privilege "administer resource manager" was not granted/revoked correctly
• Duplicate names were not displayed correctly by the Code Assistant
• Change Window to another type could fail when focus changed to another window
• Log on did not always clear the Connection button in windows
• Reconnecting all windows to another connection now implicitly logs on
• Some synonyms for V$ views were not translated correctly (e.g. v$object_usage)
• Changing a connection of a window would commit the current transaction, regardless of preference
• Export to Excel XLS could give incorrect column formats for second page
• New SQL Window preference: "Refresh posted records"
• Querying a table with a column of an inaccessible type could lead to an Access Violation
• Invoking the Large Data Editor could lead to "The configuration registry could not be read" error
• SQL Window query performance improved
• SQL Window AutoSelect SQL performance improved
• Code Assistant could display duplicate items from CANames.sql
• Performance improvement when loading files from a network drive
• Compare User Objects could not create queue tables by pressing the Apply button
• SQL Window status line would show only the first line of a column comment
• Main connection indicator colors could be set when logged off
• Editor Copy now always uses white background color
• Selecting "Other" from the connection list in a window status bar now directly shows the Logon dialog
• SQL Window performance improvement when executing large scripts
• Explain Plan Window would wait for other queries to finish in Dual Session Mode
• AppData directory is now properly determined (preferences and files are copied from old location)
• Text color improvement for the connection indicator
• Key Configuration could sometimes be cleared
• Explain Plan function would incorrectly remove into clause for field lists with subselects

• SQL Window would always print SQL text, disregarding "Print SQL" preference
• Searching within special text (strings, comments) could be slow
• Key Configuration preference could reset to default instead of using the defined keys when using multiple preference sets
• Export to Excel would interpret data beginning with = as formula
• Column names starting with a digit were not implicitly quoted in SQL statements
• Fixed issue with search in selection where incorrect characters could be replaced
• Duplicate items removed from description window
• View/Edit Data for tables with an owner with special characters would not add quotes to the owner
• UTFE characters were displayed incorrectly when Unicode support was enabled
• Loading the Macro Library could fail on Windows 7/Vista, resulting in a "list index out of bounds" error message
• Debugger could hang after an exception on Oracle11g
• Code Assistant can now complete database link names
• Copy all to Excel in the SQL Window would not have correct formatting on the second sheet
• To-Do Item List was not up-to-date when opening a package spec & body

• Fixed Access Violation when dragging & dropping an empty item in the Logon History
• Fixed Access Violation in the File Browser when adding a new folder
• Order of items after "Open All Items" from a project was not correct
• Project Groups could be removed after doing project options
• Find would not work correctly with a column selection scope
• Edit > Selection > Apply Syntax Case/Color Mark/Comment did not work for Column Selections
• Describe Window now also shows the view comments in the header
• Export Tables would change nls_date_format in single session mode and dual session mode
• Auto Replace now supports Undo to continue with "non replaced" text
• Debugger can now show PL/SQL Table elements indexed by a string
• Object Browser could sometimes perform "double-click" action when using the cursor right key
• Unicode characters from DBMS_Output were not displayed correctly
• Right-clicking on an empty area in the Window List did not show the popup menu
• Highlighted search hits are now cleared when editing the text
• Fixed drawing performance issue with Diagram Window in zoomed mode
• DDE now remains enabled for Windows Explorer open command (DisableDDE parameter to revert)
• PL/SQL Developer main window could not always be minimized
• To-Do list would not always be updated when switching editors in a Program Window
• Case expressions could cause incorrect "Unused assignment" hints
• File Browser would not show all files for large directories (>1000 files)
• Support Info showed OCI Version 11.1 on a 10.2 client
• Export Tables tool will limit the line size to 2400 characters in SQL Inserts format for SQL*Plus compatibility
• Reports did not always calculate subtotals correctly
• Compiler Hints could not be enabled/disabled

• Required version for French, German, Spanish, Russian and Chinese Language Packs
• SQL Window print would not always print date in header
• Window List order was not always preserved
• Large Data Editor text could be invisible
• Ampersands in field names would lead to accel keys in grid headings
• User Editor now adds quotes to password when needed
• Object Browser would show duplicate columns when a cluster with the same name exists
• Incorrect "Not all records are fetched" warning could occur in the SQL Window
• PL/SQL Beautifier option "Split join expression before ON" did not always work
• Timestamp fields were not formatted correctly in Single Session Mode

• File > New > Program Window submenu and could be empty
• Object popup menu item "New" could do nothing

• Code Assistant did not work anymore for subselects
• Unpinned dockable tools did not always retract

• Fix for MonitorFromPoint Access Violations
• File Browser would not always sort the files
• Parentheses would not be highlighted when the closing parenthesis is the last character in the editor
• SQL results, Copy To Excel would not wrap at 64K rows
• Exporters have an option for ANSI (plain text) export (a second option in the file dialog filters)
• Session Window headings would be empty after reconnecting to a newer Oracle Server version
• Shortcut for Edit > Full screen changed from F to L to remove duplicate with Find & Replace
• SQL Window could mark edited number fields without scale and precision as invalid (red)
• Project popup "Object Options" is now disabled when not logged on
• Text Editor of the Large Data Editor did not have the editor background color
• When registering file types, Application will also be (re)registered
• Open <cursor> for <with statement> was not beautified correctly
• Declared exceptions were not highlighted in the Program Window
• Variable highlighting and Code Assistant Popup did not work consistently for Triggers
• Changing the window type would incorrectly convert Unicode characters
• Dropping and purging multiple items now has progress bar and Esc option
• Holding the mouse cursor over an indexed item during debugging did not show the value
• System privilege selection list of the User Editor was too small (4 items)
• Resolving table names failed on Oracle Server 9.0.x
• Text Importer, paste data would not always work
• Code Assistant pane could be trimmed by window edge
• Editing Scheduler Date/Time fields could lead to '<date/time> is not a valid date and time' message
• Project Groups now fully support Unicode names
• SQL Window Previous/Next SQL keys did not work when no result grid was present
• Docking panes would retract when popup menus or dropdown lists were displayed
• Query Data and Edit Data functions did not handle mixed case identifiers correctly
• Code Assistant could popup after executing a SQL Window
• SQL Window Column Total > Count now only counts non-null values
• SQL Window Column Total > Sum precision improved for 0.0 results
• Command Window RunTestSet command could not read directory/file names with spaces
• PL/SQL Beautifier "Init Caps" option would capitalize single character prefixes (P_Empno instead of p_Empno)
• Fixed File Browser bug repeating the same subdirectory
• Object Browser Double-click action was unpredictable (would expand/collapse instead)
• SQL Window timer would keep counting while an error message was displayed
• Fixed Access Violation in TreeNode.GetParent
• AutoReplace was only invoked when positioned before a whitespace character
• DBMS Output could not process lines longer than 4000 characters
• SQL Window Export Query Results button would mess up results with multiple result sets
• PL/SQL Developer would give an incorrect "owned by different user" warning with a loaded file when switching users
• Support added for 'identified by values <encrypted password>' clause for User DDL
• SQL Window would always print with the Courier fount
• Fixed bug with file names in title and window list and projects when using desktop parameter
• Keywords are now saved under Application Data in the user profile
• When updating a schedule, start_date and end_date could be updated without making a change
• Browser Object status would not always be updated correctly after docking/undocking
• DBMS_Metadata functions did not retrieve UTF8 text on a non-UTF8 client
• Code Assistant would not describe embedded object types (e.g. Person.Address.|)
• The Object Browser did not show columns for Bitmap join indexes
• Window List will draw faster
• LANGUAGE=<xxx.lang> command line parameter added
• Fixed Access Violation in Data Generator
• Copy grid selection did not add cr/lf after the last line
• Command Window would sometimes need <enter> twice to execute recalled statement
• Invoking the PL/SQL Beautifier did not update the Bookmark List
• PL/SQL Beautifier could not parse merge statements with case expressions
• Floating tools could steal the focus after using the Find & Replace function
• Double-clicking a project file will open a new PL/SQL Dev instance
• A newly created SQL Window after pasting a SQL text on the PL/SQL Developer work area could be closed without a "Save SQL Window" warning.
• Code Assistant did not list parameters for locally declared object functions or procedures
• Command-line parameter NoCheckFileDate added to suppress checking for changed files
• SQL Window Copy All To Excel did not set cell format correctly
• Commit/Rollback buttons could have wrong status after a cancelled import
• Project Build could give continuous error message for deleted files
• Comments before a program unit could be indented incorrectly
• Code Assistant popup could hide partially under Windows taskbar and/or sidebar
• New PL/SQL Beautifier rule "Split JOIN expression before ON" added for 7.1 compatibility
• Substitution variable integer validation was limited to a 32 bit integer
• Pipelined functions could lead to incorrect "function does not return a value" hint
• AutoReplace is no longer automatically invoked when typing comments or strings
• SQL Window could give a "not all records are fetched" warning in Single Record Mode
• PL/SQL Beautifier would not always format item lists correctly for a WITH statement
• Search > Replace All did not always work correct ('''' replace by '' would give ')
• Improved multi monitor dialog positioning
• Execute button was not updated correctly after saving a read-only database source
• Inserting and Updating CLOB's and BLOB's through the SQL Window now uses Temporary LOB's on Oracle 8.1 and later to facilitate trigger testing
• Compare Table Data could update incorrect fractions of a second for timestamp columns
• Code Assistant items can now be sorted
• SQL Window "Save as Template" option could show "Unexpected error" instead of a normal error message
• SQL Window execution time would be displayed during substitution variable form
• Notification time for long running queries would include substitution variable form time
• Object Browser double-click action preferences were not saved for dbms_scheduler types
• Code Assistant would not describe object type columns
• Two quick shift-clicks on the Window List could cause an Access Violation
• Replace All could result in an endless loop
• Hyperlink navigation from a DML statement would sometimes incorrectly navigate to the table or view
• Find menu shortcut keys would not get default values after upgrade to 8.0
• File Browser would sort case sensitive

• Posting NVARCHAR2 unicode data in the SQL Window could lead to truncated results

• SQL Window would not parse statements correctly when immediately followed by comments after the semi-colon
• Compiling a program unit with debug information on an Oracle11g database with PLSQL_WARNINGS='ENABLE:ALL' would lead to a PLW-06015 warning

• Fixed some access violations
• Inserting a record in the SQL Window would pass null for Unicode columns instead of omitting it from the inserts statement
• Support for the ODAC instant client added
• Translated help files were not used
• Performance improvements for some dictionary queries
• SQL Exporter did not export very old dates in date format
• SQL Exporter could export floats with comma as decimal separator

• XML editor of the Large Data Editor replaced tabs with spaces
• Files copied in the Windows Explorer can now be pasted in PL/SQL Developer
• Program Window preference "Safe compilation" could not handle quoted program unit names
• Internal HTML Viewer did not process Ctrl-C
• HTML Help indexing did not work for older Oracle versions
• Test Window variable hints would not always be cleaned up
• SQL Window would always switch to SQL tab after execute
• Text Importer would not show correct count if some records failed
• Large data Editor now updates the size while editing
• HTML Book Path was not determined correct under Vista
• Compile Invalid Objects tool could show "Properties of <object> not available" after reconnecting
• Tab order in message boxes with "Don't show this message again" option was confusing
• Command Window beautify command would save files in UTF-16 format
• New Plug-In functions: BeforeExecuteWindow and AfterExecuteWindow
• Optimization of dictionary view queries
• Fetching View DDL from the dictionary now removes trailing empty lines
• Printed query plans could be truncated
• Folders for Jobs and Queue tables added to the User > Objects folder of the Object Browser
• Preferences could ask for "save changes" when nothing was changed
• Adjusted HTML Help default book selection for Oracle 11g compatibility

• Windows Vista compatibility improvements:
• Setup is now fully Vista compatible
• Registering application and file types is now Vista compatible
• Writing files takes Vista security into account
• Macro recorder did not work
• Improved indexing method for HTML Help
• Find dialog would not reopen normal once closed minimized
• SQL Window now only handles forward slash as a command separator at beginning of line
• Reloading changed files did not work correctly for SQL Window
• Copy from a grid did not work when "Include Font Style with Copy" preference was enabled
• Copy (without header) added an empty first line
• Replaced sys.all_synonyms & sys.dba_synonyms by all_synonyms and dba_synonyms to allow for private or public synonym replacement for these views
• Table partitions for index organized tables on Oracle9i and earlier did not show
• Source files in Unix format (LF instead of CR/LF) would not always be parsed correctly
• Command Window would not handle "whenever oserror" correctly
• Command Window "beautify" command did not handle Unicode characters correctly
• Command Window would allow mouse to place the cursor before the prompt on the command line
• Large Data Editor, text editor did not wrap text correctly
• Explain Plan Window could not handle XMLQuery with RETURNING CONTENT clause
• SQL Window could not edit data from a table across a database link
• Pressing enter when selecting a substitution variable value from a list would also close the substitution variable form
• Tables from the recycle bin would show up under Users > Objects > Tables in the Object Browser
• User Export Objects with the "Include Owner" option did not include the correct owner for foreign key references to tables of other owners
• FLOAT columns would not include precision
• Copy/Paste in result grid improved to handle quotes better
• Projects could not handle files with comma in path
• Fixed Access Violation when changing window type to Program Window
• Plan Window did not show correct when changing window type maximized
• ODBC Importer could use invalid variable names (based on ODBC field names)
• Command line parameters viewobject and editobject did not work correctly

• Describing a program unit on an Oracle7 client or server would give incorrect parameter names
• Switching to the log tab page after a Table Import could lead to hang-up
• Command Window could give wrong highlighted text for errors
• Data Generator Sequence Within Parent option did not work
• AutoReplace templates inserted a space before the text
• Inserting Templates would add a line break
• Import Tables: clicking on the From/To User combo box would cause "Invalid class typecast" error
• Selection Uncomment did not always work
• Views did not handle Unicode characters correctly
• Large Data Editor did not handle Ctrl-Insert as copy
• Large Data Editor had an issue with trailing blank lines
• Escape did not always close Large Data Editor, depending on current tab-page
• Save As did not work when a window was renamed
• Preferences could have the "changed" flag set when nothing was changed
• Fixed logon history could have spaces in front of logon
• Project open/re-open/new did not work correct when a project was already open
• Project Re-open dropdown could display trimmed data
• Command Window AutoReplace could stop working after an execute
• Import Tables tool did not import Unicode CLOB's correctly in PL/SQL Developer format
• Find (& Replace) did not work correctly with collapsed code
• New editor preference: "Variable horizontal scrollbar"
• Window List redraw improved (flickering while compiling and speed)
• Large Data Editor: External Editor did not always convert text correctly
• Splash Screen hides after 30 seconds inactivity to prevent waiting for hidden dialogs
• Program type or name was not always correctly determined in the Program Window, when preceded by a large amount of comment
• Text Importer would not handle string fields correct in SQL function # replacement
• Drag & Drop DDL into an editor would give incorrect capitalization when Keyword Case preference is set to Uppercase
• Import Tables: removed 80KB limitation for the import buffer size
• Browser folder Users > Objects did not have a Materialized views subfolder
• Compare User Objects Show differences button would fail when using EZConnect database names
• Disabled wList Plug-In due to compatibility issues
• Querying and editing Long columns with UTF8 data did not work correctly
• Edit > Selection > Uppercase/Lowercase/etc would not enable undo button
• Template would not set cursor [#] at end
• Modify Breakpoints popup was not available in Test Window
• Cursor fields could not be queried on Oracle 9.2 and later
• User-defined browser folder queries did not follow the "Use DBA Views if available" preference
• PL/SQL parser could not handle FUNCTION or PROCEDURE as a column or variable name
• Program Window could not handle REM or PROMPT commands with certain PL/SQL keywords at the start of a file
• NCHAR character set UTF8 could lead to ORA-1461 when inserting/updating multiple NCHAR columns
• Default value for a checkbox substitution variable did not work
• Drag & Drop from the Object Browser to the Test Manager did not work
• Custom syntax highlighting through Plug-In interface works again with different styles (highlighting Plug-In)
• Fixed issue with syntax highlighting that could show all highlighting identical
• $ and # and . will be recognized as keyword characters for word select and highlighting
• Variables Window will remember size and position
• Large data Editor, XML Editor did not show node values
• Updated "Roll Up/Down" buttons for Vista compatibility
• Folded code did not unfold when navigating to a compilation error, navigating from the Code Hierarchy, and jumping to a bookmark
• All file dialogs are now Vista style when using Windows Vista
• Object Drag & Drop text now adds an empty line at the end
• Compare Table Data errors would cancel compare operation, even if "Ignore" was selected
• HTML Help window would not reopen correct when maximized
• PL/SQL Beautifier now clears the line status
• Sequence Definition Editor did not allow negative numbers for Min value, Max value, and Start with
• SQL Window result set foreign key lookups no longer fetch BLOB or CLOB values
• Table Definition Editor did not update Tablespace when pressing the Refresh button
• Code Assistant would freeze while a query is running in the same window
• Hyperlink navigation now always centers the target position in the editor
• Right-clicking on a large selection could cause a long delay with 100% CPU utilization
• Copy from result grid would not copy the first empty cells
• Keywords Case setting could result in question marks for Unicode characters
• Added "Copy to Excel" popup option for Statistics in SQL Window and Test Window
• Removed incorrect "SQL File" export option for statistics
• CSV exporter now uses the Windows defined "List Separator" instead of a fixed comma
• <Shift>+<Enter> key will now behave as <Enter>
• PL/SQL Beautifier will handle custom keywords as keywords
• Invalid regular expressions could leave Find Database Objects tool in an unusable state
• SQL Window result grid did not follow the "Use multi-row tabs" preference
• Custom keywords with a dot (e.g. package.function) were not highlighted
• View DDL is now always terminated with a semi-colon
• <Shift>+<Back> will now behave as <Back> in Grids
• Command Window could fail when repeating commands in Single Session Mode
• Starting PL/SQL Developer by opening a document from the Windows Explorer would not always work
• The NOREGISTER parameter now also prevents the "service contract expired" message
• Editor margin could disappear for Java Sources in the Program Window

• Printing could be limited to the first 10,000 characters
• Number keys would not work in editor if bookmark function keys were undefined
• Printing line numbers did not work
• Some characters could be truncated in the editor for smaller font sizes
• AutoReplace now supports templates (right-click in the AutoReplace editor)
• Added an "Editor: AutoReplace" key
• Pressing the <Enter> key would not always work in the Command Window
• Character set detection was not correct for Instant Client
• PL/SQL Editor memory leak & performance issue fixed for large comment blocks when using variable highlighting
• Special Characters preference added
• Table privileges were not editable
• Color marks would disappear when marking a selection
• Fixed issue where PL/SQL Developer would exit/crash on startup
• Find dialog did not show for some windows without an editor
• Registering an expired trial version could give a 6 days left message on the first run

• Unicode support added for query results in the SQL Window, Test Window and Report Window
• Added "Unicode enabled" preference
• Test Manager files can now be added to a project
• Esc can now be used to break entering a command in the Command Window
• Support added for WMF/EMF in the Large Data Editor
• XML Editor now shows collapsible code
• Windows that are still executing SQL or PL/SQL can now be forcefully terminated
• Command Line parameter DESKTOP=<name> added to save/load desktop layout
• Find & Replace dialog now shows the replace count
• Report Window now support HTML tags in results to show images, links, and so on
• Expand all and Collapse all popup items added to the XML Editor
• Fixed possible "Range Error" when starting on a PC that was running without a reboot for a long time (>20 days)
• Internal Query Builder would not allow creating relations by dragging columns
• Improved Text Importer data analysis to autodetect fields
• Fixed "Out of resource" errors
• Some configured keys would be cleared after a template window refresh
• Command Window sqlplus command would not add quotes on a filename with spaces
• Data Generator would not handle duplicate functions for the same field correct
• SQL Window grid would interpret specific defined shortcut keys (e.g. ctrl shift p)
• Recovery files would not always get detected/loaded (window handle issue)
• Key preference for Editor <end of line> / <begin of line> is now used (was fixed to Home / End key)
• Adding files to project would not always autodetect file type
• Data Generator handles date conversions better
• Alternate row colors now works properly for sorted grids
• Preferences were stored on startup, possibly overwriting preferences of a second instance
• Continuing a query in a SQL Window with multiple queries could cause "List index out of bounds" error
• SQL Window result grid had lost the 'fixed' rown umber column
• Program Window could not parse sources with large amounts of comments before "create or replace"
• Unused parameter/variable hint could be missing if the name was only used as a parameter name
• Hyperlink navigation did not work for table or view aliases
• Recompiling a trigger after a debug session would incorrectly update the trigger source in the debugger
• Session Window columns are no longer reordered for session filter queries with an explicit column list
• MERGE statements were not automatically picked up for the Explain Plan (F5) function
• Compare Table Data would raise "column is not a timestamp" error when comparing timestamp columns
• Placing the Triggers Browser folder in the Tables Browser folder would cause an Access Violation
• Unused assignment hints could be missed when multiple statements are placed on one line
• Shortcut keys for special copy items did not work
• SQL Window Next/Prev record in single record view did not work correct for sorted results
• Collection attributes within embedded object fields could not be queried
• Command Window now spools to preference directory or script directory by default

• Delete Program in Program Window now asks for confirmation
• Text Importer could generate field names like "FIELD__TYPE_"
• Text Importer: added 'End at line-end' preference to allow importing records with a different number of fields per line
• Diagram Window fixes and enhancements:
  • "Save as image" and "Copy as image" added
  • Bug fixed with printing/save/copy when scrolled
  • Bug fixed with printing/save/copy which could clip lines at the right
  • Fixed some moving/aligning issues
• Fixed some Query Builder issues selecting fields
• Query Builder did not allow sorting of fields, now possible in "parts" section
• Added a warning for actions on an incomplete result set in a SQL Window
• Fixed some multi-monitor issues:
  • Position of Splash screen / progress dialog
  • Position of message boxes
  • Restoring main window on a specific monitor
  • Windows created on secondary monitor would be positioned wrong
• Logon History could get reduced
• Saving in Unix format could use CR line separator in some editors
• Saving (recovery) files would scroll cursor into view
• Not all key definitions would work in all editors
• Added a "file dialog details view" preference
• Command Window: SET SQLPROMPT added (same as SET PROMPT) with case sensitive [params]
• Macro Library improvements:
  • Fixed bug pasting from one macro to another
  • Selections can now be moved up/down
  • Removed FF items
• XML Editor could have initialization problem caused by registry write access
• HTML Help improvements:
  • Improved detection of description
  • Improved support for Oracle 10 html files
  • Store HTML Document directory
  • Remember selected books after a new build
  • Books were not sorted
  • Search now for separate words (google style)
• Command Window with formatted output did not handle output with linebreaks very well
• Save Layout didn't work properly for Text/ODBC-Importer
• Compare User and Compare Data could be slow saving large results from editor
• Compare User Objects would sometimes not see dropped columns
• Stack dump would display type specification instead of type body
• View DDL did not include UNDER <Superview> clause
• Large Data Editor was not always accessible in SQL Window with multiple result sets
• Substitution variable escape (&&) did not work if no other substitution variables were present
• Object View DDL could include column aliases
• Empty line could appear for cache clause in Table DDL
• Compare Table Data tool did not always include time fraction of date values
• Refactoring Rename function could not rename exceptions
• Refactoring Rename function would also rename parameter names in procedure/function calls
• Hour Glass is now displayed when connecting to the database
• Locating text in a source from within Find Database Objects would not always find the first occurrence
• SQL Window Single Record view mode preserved with a single result set
• User Definition Editor did not always set Password expire state correctly
• New preference: Files > Format > "Export to Excel with SQL statement"
• Added OnTemplate in Plug-In interface
• Desktop popup extended with some items from the File menu
• Improved auto detection of number/string in Text importer (multiple dots)
• Setting the hot track color to the editor background color would hide all highlighted text
• Clicking on the status line in a SQL Window for a cursor result set would clear the results
• Clearing results in SQL Window will now set focus to Editor
• Bookmark list is now immediately updated when closing a window with bookmarks
• Editor column selection did not work correctly if first visible line was empty
• SQL Window popup menu item "Clear results" was missing for commands without a result set
• When printing with header, a long filename would not always fit
• Text Importer now uses field types from Oracle if possible
• Command Window could not handle REM-- as comment
• Support added for Oracle10g alternate quoting (e.g. Q'[Don't care]') for syntax highlighting, PL/SQL Beautifier and Code Contents
• Substitution variables could not parse lists that span multiple lines
• The correct preference set would not always be calculated if not connected

• Fixed several ODBC Importer issues
• Fixed "Not enough storage" problem
• Several SQL Window parsing errors fixed
• Added two parameters for HTML books:
  HTMLBooks= to determine the directory for the book index files
  HTMLBookSelection= to determine the path for the book selection
• HTML Export did not use character set and header preference
• Hint preferences grid did not always show scrollbar
• CSV Export did not export null values in the first field(s)
• Report Window layout grid selection lists did not work correctly
• Comments were removed from statements when stored in the recall buffer
• SQL Window would allow tab changes during execution, which could cause errors
• SQL Window fetch buttons would focus editor after completion
• SQL Window "Executing..." message would immediately be cleared
• SQL Window QBE query is now displayed again for scripts with 1 statement
• SQL Window column width and order preserved when re-executed
• Switching from Single Record view could cause "Row index out of range" error for empty result set
• SQL Window could not be switched to Single Record view for cursor result sets
• Preferences menu item groups (at the left) would not always have enough room for contents
• User Interface preference "Autocomplete dropdown lists" added
• User Interface preference "Position messageboxes near mouse pointer" added
• Edit > Next/Previous Tab Page could cause hang-up or error message
• Added Shift-Delete/Insert (cut/paste) in Large Data Editor
• Support for Templates in Explain plan Window popup menu
• Pasting data in Grid could give empty value on next row
• Edit Object Window could not copy/paste grid data
• Explain Plan now also enabled for insert statements
• Comments in the where clause of a browser filter could cause "missing right parenthesis" error
• Double-click on a Job in the Browser would do nothing
• Substitution variable history would override case of entered text
• Copied & pasted authorizations would not be saved when pressing OK
• Plug-In function IDE_ExecuteSQLReport would give "cannot focus invisible window"
• Plug-In event OnPopup was not called for Session Window popups

• Fixed an access violation when starting the Query Builder on some Windows versions
• Fixed dbms_output ORA-06502 error on 10.2 for lines > 255 characters

• Compatible with Oracle10g Release 2
• Fixed memory leak in data generator
• plsql_debug mode only applied during compilation to prevent ORA-00600 errors
• Report Window did not recover correctly from killed session
• Improved TIF compatibility for the Large Data Editor

• Add debug information menu option did not work if "add debug info when compiling" preference was disabled

• Insert Template context menu would hide first item and add dummy item
• Insert Template did not show subfolders
• Connection preferences in registry (Logon section) did not work
• Projects: progress while compiling now shows actual number of compilable files (compiling: x of y)
• Projects: not all compile errors were indicated
• Projects: handled errors in command files for WHENEVER ... FAILURE
• Added missing Oracle10g plan_table columns
• SQL Window AutoSelect Statement function did not handle nested PL/SQL Blocks correctly
• Command Window could not process "create or replace type ... ( )"
• Command Window could not process "create or replace and compile java source ..."
• Command Window would insert empty lines when showing dbms_output
• Command Window Show Param[eters] support added (with additional info option)
• Command Window Set Arraysize support added
• Command Window Set Time support added
• Command Window would not exit nested scripts for 'whenever ... exit'
• Command Window now supports environment vars (%var%) for commands with files (spool, @, store, get)
• Sorting a grid did not always sort strings case insensitive
• Compile Invalid Objects initial query performance improved
• Explain Plan Window now allows you to execute alter session statements for the current session
• Explain Plan item was disabled for WITH statements
• Text Editor [Esc] would activate Help
• Inserting templates no longer interprets a "/" when not creating a new window
• Pasting columns in Table Editor would give AV
• External tools now support "as sysdba" in connect string
• All items modified by Find > Replace All are now grouped into one undo action
• Code Assistant could remove spaces typed after a comma
• Using the Find function in the Large Data Editor could suppress changes
• Key configuration preference added for SQL Window: Clear Results
• Fixed problem with missing default keys
• Data Generator could not handle SQL(...) for date fields
• SQL Window column moving was not preserved after re-executing the same or similar queries
• Compile Invalid Objects would ignore objects excluded from debug information
• Application title in the taskbar could be cleared after changing a connection
• Nested if/then/else structures could lead to incorrect "Unused value assignment" hints
• Using table.column%type declarations in a Test Script would cause Code Assistant problems
• SQLPATH environment variable was not used by Command Window
• Fixed incorrect handling of formulas when exporting report to Excel
• Fixed AMPM problem when exporting report to Excel
• It is now possible to create a default user.prefs by placing this file in the default preference directory
• Recent objects folder was not properly refreshed
• Templates for a command window can now indicate to open the editor page [$WINDOW TYPE = COMMAND,EDITOR]

• Package bodies, type bodies, and materialized views would disappear from user defined folders
• Opening a user defined folder when disconnected would lead to "Not logged on" messages
• Reports menu did not show directories with only subdirectories correct
• Instantiable and final member procedures were not displayed correctly in the Code Contents
• Text Importer file associations are now stored in user.prefs, not in Import\import.files
• SQL() function added to Data Generator
• Table creation DDL for partition values ending with a parenthesis were incorrect
• Popup menu in various editors were missing "Insert Template" submenu
• Fixed "cannot convert string to double" error
• Fixed problem with disappearing last row while pasting into grid
• Title of Program Window would not change from View to Edit if Window changed to Edit mode
• Command windows now displays CLOB and XMLTYPE in accordance with the SET LONG setting
• Replace All in Find dialog now also includes the current selection
• Code Assistant could not resolve local variable names in a Test Script or Trigger
• Code Assistant could not resolve variables of a type in another schema
• Command Window and SQL Window will no longer silently retry after "ORA-04068, Existing state of packages has been discarded"
• Using a variable in an exception handler could cause incorrect "Unused variable value" hint
• Double-clicking on a package in the Object Browser could display 2 Program Windows if the package body was wrapped
• Pasting data in result grid did not update NULL indicator color
• Added sound to Warning and Error messages
• Data Generator could give a "list index out of bounds" for Files() function with only one file
• Logon History did not always display all grouped items
• Fixed link to Direct Oracle Access (5 variables limit)
• Copy comma separated from browser would not work for closed folders
• Suppressed dialogs (Don't show this message again) still gave a sound
• Duplicate reports (same path and file) in reports menu prevented
• Program Window could split source on a slash in the middle of a line
• Dropping an object in the SQL Window would not update the Object Browser
• Replace All was not restricted to the selected scope
• Preference "Wrap to start / end of file when text is not found" did not work
• Using +variable or -variable could cause incorrect "Unused variable" hints
• Command Window now issues a warning when a connection is re-established
• Refreshing the Session Window with a disconnected PL/SQL Developer session would cause errors
• SQL Window always auto-sizes columns unless you have explicitly resized a column
• Recent files list is now passed to a second PL/SQL Developer instance

• Fixed connection delays and ORA-12154 errors when using Oracle Names 9.0 or 9.2
• Using the Large Data Editor could lead to instability
• Some applications could not be started when PL/SQL Developer is running
• Memory overhead in object list reduced (Export User Objects, Compare User Objects, and so on)
• Code Contents parse error fixed when using the words "left" or "right" in a condition
• SQL Window "Next SQL" button did no longer clear the editor after the last SQL
• Text Importer replaced only 1 occurrence of # in an SQL function
• The View function for program units would bring an already opened, editable window to the front and make it read-only
• Creating/Editing users with special characters would fail
• Fixed error while downloading updates & News details
• Preferences are now synchronized between different instances on the same PC
• Fixed problem with copy/paste multi line data in grid
• PL/SQL Beautifier would raise error for table.column expression with a space between table and .column
• XML editor would replace header with <?xml version="1.0"?> after making a modification
• Large Data Editor could add 0-byte to BLOB data
• Code Assistant did not come up for lower..upper expression without spaces
• Data Generator did not generate master/detail/detail data correct (only test was correct)
• Text Importer would not always handle quotes correct
• Large Data Editor could enable word-wrap in other editors
• Preference for maximum size of recall statement would not always be saved
• Improved the resizing behavior of the Plan Window
• Safe Compilation preference did not work correctly if owner preceded the object name (create or replace package scott.employee ...)
• Clear function for SQL, Command, Test and Report Window did not also clear the "Saved" indicator
• Left-clicking on a Code Contents item will now always navigate to the start of that item in the editor
• Preferences will be stored in Application Data Path if the default directory is read-only
• Not all font and color preferences were applied immediately in preference dialog
• Date format preference could be changed externally
• Changing the Session Mode preference could cause errors if PL/SQL Developer is not restarted
• Find dialog would be displayed at wrong position for multi monitor systems

• Partitioned tables were not detected correctly on Oracle8i
• Partitions tab page was visible when viewing a non-partitioned table
• Code Assistant did not describe materialized views
• Code Assistant did not describe record types declared in another package
• Code Assistant could remove spaces typed after a comma
• File -> Close All could lead to invisible confirmation dialog
• Font Bold & Italic preferences did not work for browser and grid
• Key Configuration preference would not handle all keys properly
• Compare User Objects could incorrectly change column properties when column order for source and target table is different
• Large Data Editor had problems with XML data with lines > 65000 characters
• Preference "Use DBA views if available" could cause ORA-00942 after switching from a DBA user to a normal user
• Compilation errors were not displayed when "create or replace" and object name are on different lines
• Could no longer connect with just / for externally identified users
• Deleting a column selection in the editor could also delete adjacent highlighted text
• Dropping a java source from the Object Browser would cause ORA-29501
• PL/SQL Beautifier did not format all ANSI join types correctly
• On Oracle7 Explain Plan and Test function did not replace PL/SQL variables by bind variables
• Text Importer would only import 99 records when pasting from clipboard
• Data Generator did not handle a master with 2 details correct
• UxTheme related errors fixed
• Browser Folders would not save connection property
• TSV Exporter would skip first field if it was empty
• Large Data Editor now closes when pressing Escape
• Compiling a body with a missing or invalid specification with "Safe compilation" preference would give compilation errors with temporary object name
• Hyperlink navigation did not work correctly for compound custom keywords
• Hyperlink navigation did not immediately update Code Contents
• Generating a Test Script for a non-packaged program unit with parameters with user-defined types would not create local variables with correct types
• Dropping an object in the Compile Invalid Objects tool would not update the compilation error list
• Fixed a problem starting specific applications when PL/SQL Developer is running
• Data Generator number precision displayed for fields with a scale of 0 would not be correct
• Explain Plan and Test function now also replaces constants by bind variables in select statement
• Pressing a cell button in an empty Single Record grid in a SQL Window would cause an error message
• Export to Excel could display cells as #### due to column width
• SQL Window now preserves result message after navigating in result grid when "Show dictionary info" preference is set
• Tables folder in Tablespace folder in Object Browser did not list partitioned tables
• Compare User Objects memory usage optimized
• Compare User Objects list included tables from the Oracle10g recycle bin
• Fixed splitter problem and alignment of editor in XML Editor
• Oracle Logon preference "Fixed Users" is now stored encrypted
• Excel interface would not handle Japanese characters properly
• Fixed "Invalid pointer operation" errors

• Support for Oracle10g EZCONNECT added
• Performance of "Copy to Excel" function improved
• DDL for synonyms now uses "create or replace" syntax for Oracle 9.2 and later
• Pressing an "Auto refresh timer" button now immediately executes the Window
• Shortcuts Plug-In enabled again
• Scrollbar in Explain Plan function now scrolls all contents
• Compare User Objects would try to rename columns when column order is different
• Code Hierarchy did not have Explain Plan and Test popup menu items for select statements
• Executing a Report would copy the SQL to the clipboard
• Report would not ask for password when "locked for others"
• PL/SQL Beautifier preview did not show effect of "Wrap zero level AND/OR" option for Control Structures
• Proxy settings added for Updates & News
• Renaming an object in the SQL Window could lead to incorrect "Object has been deleted" message
• Beautifier DML Rule "AND/OR under where clause" was always enabled
• Code Contents could sometimes be blank or out-of-date
• Fixed various access violations
• Explain Plan function did not replace record field PL/SQL variables in SQL text by bind variables on Oracle 9.0 and earlier
• Safe compilation could fail if the package body contains references to objects with the same name in another package
• Disabling the "Include Storage" option during Export User Objects would still include partition storage information
• Text Importer now correctly autodetects text with pipelines
• Large Data Editor now supports undo, redo, find and select all
• Text Importer data preview would not highlight multi line fields correctly

• Program Window enhancements
• Code Hierarchy pane added
• Code Contents extended with code structure and hot tracking
• Compiles in background if session mode is "multi session"
• Highlight if, loop, case, and blocks
• Safe compilation preference added
• Save before compilation preference added
• Oracle10g PL/SQL Compiler warnings supported
• Support for partitioned tables added
• Support for materialized views added
• Support for compressed indexes added
• Support for reversed indexes added
• Support for queues added
• Support for queue tables added
• Support for NLS Length Semantics added
• Support for LOB and nested table column storage added
• Support for column renaming added (Oracle9.2 and later)
• Editor enhancements
• Hyperlink navigation now works in all SQL and PL/SQL editors
• Highlight parentheses
• Table and View drag & drop into editor can now launch the Query Builder
• Find function can now wrap to start/end of document if the search text is not found
• Append function added to append text to the current clipboard text
• Sort function added to sort a selection
• Guideline function added
• SpecialCopy syntax extended with #define compress
• Multi-line strings properly highlighted in SQL and PL/SQL editors
• Oracle10g keywords highlighted in SQL and PL/SQL editors
• Code Assistant enhancements
• Support added for packaged record types and rowsubtypes
• Support added for cursor variables
• Support added for select statements on inline views
• Home / End key will go to top / bottom of the list
• Wraps to top / bottom from last / first line
• Authorization added
• To-Do Items added
• Data Generator tool added
• New preference dialog with preference sets
• External Tools generalized as External/Session Tools
• New Large Data Editor for CLOB, BLOB, LONG, LONG RAW and VARCHAR2
• Find Database Objects improvements
• Search for object name, owner, status, creation date range, and modification date range
• Criteria can be saved and loaded
• Export User Objects improvements
• Include Storage option added
• View button added to view the resulting script
• Compare User Objects improvements
• Option added to include storage in generated DDL for new objects
• Table column renaming supported (Oracle9.2 and later)
• Export Tables improvements
• Include Storage option added for SQL and PL/SQL Developer format
• Include Privileges option added for SQL and PL/SQL Developer format
• HTML Manual enhancements
• Multi-tabbed search results
• Roll up / roll down buttons
• Search text history
• Object Browser enhancements
• User defined folders added
• Folder hierarchy
• Folder color
• Connection specific folders
• Add/remove objects through right-click in Object Browser
• Super/Subtype displayed for type objects
• Column renaming added (Oracle9.2 and later)
• Dropping a user that owns one or more objects is now possible after an explicit confirmation
• Object popup menu now shows the debug information status
• Recycle bin added for dropped tables on Oracle10g with Purge and Restore functions
• AutoRefresh option added for Session Window, SQL Window, Report Window, Test Window, and Command Window
• Added "Change Window to.." to popup menu for SQL Window, Program Window, Test Window, Command Window and Report Window
• SQL Window enhancements
• New number layout preference: "Formatted with thousand separator"
• New "Null Value Color" preference
• Object Browser is immediately updated after creating / dropping / altering and object
• Compiling a view will save & restore instead of triggers
• Query can now be saved as "Standard Query" for a Table, View or Materialized View
• Direct XMLTYPE query support on Oracle Net 9.2 and later
• Saving a view source now provides the view name as default filename
• Clear, Clear Result and Select All added to popup menu of Single Record view
• ReadOnly substitution variables added
• Hidden substitution variables added
• Test Window enhancements
• New debugger preference "Never add debug info for objects"
• Current debug line is now centered
• Watches are saved and loaded with the Test Script
• Plan Window enhancements
• Copy function prefixes each item with its name
• Oracle10g columns added
• Command Window enhancements
• Set prompt command added
• Exit command can now exit PL/SQL Developer
• New PL/SQL Beautifier options
• Parameter declaration: List at left margin
• DML: Split at zero-level AND/OR
• DML: AND/OR after expression
• DML: AND/OR under where clause
• Control structures: Split at zero-level AND/OR
• Control structures: AND/OR after expression
• PL/SQL Beautifier enhancements
• Support for Merge statement added
• Support for Join syntax added
• Constants are aligned when "Align declarations" is enabled
• Recall Statement enhancements
• Buffer size and location Preferences
• Export to CSV file
• Find function
• Oracle10g Instant Client support added
• All combo boxes now have AutoComplete functionality
• Taskbar icon now only displays connection information
• File > E-mail item added
• Keyboard search in property windows
• Popup menu added to the desktop with some primary functions
• Rollup button added to Window List and Template Window
• Shift-click in Window List closes the selected window
• New command-line parameters
• commandfile: execute a command file
• viewobject: view database object
• editobject: edit database object
• nolugins: don't load Plug-Ins

• Oracle10g related fixes:
• HTML documentation was not indexed correctly
• Oracle Home was not correctly detected on an Oracle10g client
• Explain Plan Window caused ORA-01986 errors
• Debugger now requires DEBUG CONNECT SESSION system privilege
• Improved Direct Oracle Access Interface:
• Fixed problem when returning more than 5 variables
• Fixed possible lock when sending back modifications
• Starting PL/SQL Developer from within Delphi/C++Builder could cause exception

• Could not use LOB's or Objects on Oracle10g
• Number precision would be incorrect on Oracle 9.2.0.4 and 10g
• Fixed Plug-In function IDE_GetPopupObject from Plan Window
• Fixed Command Window problem with quotes in comments
• Program Window preference "Ignore Unrecognized PL/SQL" added
• Displaying a collection column or attribute from a cursor result set in a Test Window would lead to "Not logged on" error message

• Multi-Monitor support added
• Selecting an item with username and password from the list will now immediately connect
• Fixed several Access Violations
• Edit > Redo would redo all changes
• Command Window fixes:
• Help command now uses html help (or supported commands for help ?)
• When executing a command file from the clipboard, Echo would always be on
• Timestamp values could not be queried
• Executing commands in dual or single session mode while another window is running would cause hang-up
• Code Assistant fixes:
• Did not use original case for local constants and program units
• Would remove spaces and tabs until the next word on the same line when inserting text
• Limited to 1000 items to prevent performance issues
• Crash recovery fixes:
• Application title would not be correct
• Maximized windows would not be restored correct
• Suppressed redrawing of window list when saving recovery files
• File > New Instance no longer passes userid parameter
• Report Window would always have all edit menu options enabled, unrelated to selected tab page
• Program Window "Clear Errors" now also clears highlighted error line
• Editors would not see text drag & drop as a change
• Result grid in SQL Window would allow cut and paste, even if locked
• Fixed setup problem on multi-monitor systems
• Saving a file under another name within a project, did not enable "add to project" menu item
• Fixed report problem when sum per break would coincide with pagebreak
• Disabled Export items while exporting
• Test Window would not show output when package state is discarded
• Joined substitution variables (&var1&var2) would not be processed correctly in SQL Window, Report Window and Command Window
• Generating a Test Script for a method with a collection attribute would result in incorrect PL/SQL
• Library did not contain trailing / when exported, which would cause an error when the generated script is executed through SQL*Plus
• Selecting a SQL statement including the trailing semi-colon could cause ORA-00911 error
• Fixed "Beautifier caused an error" for alias[space].field expression
• Bookmarks and breakpoints would disappear when using the PL/SQL Beautifier
• Code Contents could fail for concatenated case expressions
• Fixed erroneous cursor down key behavior on last line in editors
• Fixed grid copy issue for specific international (Greek) fonts
• Fixed case sensitivity issue for custom keywords (international characters)
• Added some missing Paste items in popup menus
• Passwords that start with a numeric character are now automatically quoted
• Adding a variable to the watch list while the debugger is executing a step caused a crash
• Job interval field was inadvertently limited to 61 characters
• Program Window name tab was not always correct for packages and types
• Improved Copy/Paste in Grid in single record view
• Not all dialogs supported [Enter] and [Esc]
• When changing Reports or Documents, the main menu items could get reorganized
• Logon history list could have the "Remove" option from the popup disabled
• Record/Object assignments could cause incorrect "Unused value assignment" hint
• Excel export now declares strings to prevent interpretation by Excel

• Released version 1.1.0 of the plsqldoc Plug-In
• Edit button added to description in layout section of Report Window
• Bookmark Next/Previous menu added (with shortcut)
• Load and Save button added to Text Editors
• SQL Window Single Record View now allows sorting
• Query Builder did not update where clause after drag & drop a column name
• Fixed "cursor down at end of editor" issue
• Special Copy definition now has #define to control string character replacement
• Toolbar buttons for external tools did not get enabled/disabled
• Export Tables grid did not sort on dates correctly (incorrect date format)
• Substitution variables had to be declared in order of usage
• Secondary substitution variables did not inherit properties from the primary variable
• Switching to Single Record View with a function key in the SQL Window would not size the column widths correctly
• Code Contents fixes:
• Could not handle variable declarations with case assignment
• Could not handle language keyword in declarations
• Could not handle nested case expressions
• PL/SQL Beautifier fixes:
• Numbers that start with a decimal point (eg .13) would not be formatted correctly
• Table.* would not always be formatted correctly
• Secondary select statements from a Union, Minus or Intersect would be incorrectly indented
• Could not handle language keyword in declarations
• Keyword followed by string without a space would cause error (e.g. execute immediate'select * from dual')
• Command Window could not connect when userid command-line parameter was specified
• SQL Window would set focus to grid when switching tab pages
• Warning for Update or Delete all records now occurs only once
• In Multi-Session mode the AfterConnect.sql script would cause serialization of the first execute of SQL Windows, Test Windows, and Command Windows.
• Canceling a debug session with an infinite loop could cause hang-up
• Large collections (> 1000 elements) could not be viewed in debugger. They are now truncated to 1000 elements, and a warning is displayed.
• XML Export could not handle column names with invalid XML name characters (e.g. # and $)
• Fixed cursor left en right 'lock' in single column grids
• Command Window now supports PlugIn command to call Plug-Ins
• Initial object query in Export User Objects and Export Tables could not be cancelled
• Table could not be described when using a join keyword in a select statement

• Released a new plsqldoc Plug-In
• Post changes button in SQL Window was not enabled when cell button was clicked to make a change
• Lookups for check constraints in SQL Window included quotes for character values
• Lookups for check constraints and foreign keys in SQL Window enabled in QBE mode
• F4 could not be used as a function key in the Object Browser
• DDL incorrect for views with check option without constraint
• Case insensitive search did not work with national characters
• Debugger did not display empty string variable values
• PL/SQL beautifier did not format collection element fields correctly (coll(index).field)
• Delete records option of Import Tables tool was not remembered
• Subsequent && pairs (escaped substitution variable prefix) would be replaced by one &
• && in substitution variable value would be replaced by &
• Printing HTML with Internet Explorer viewer now without header, footer and with correct orientation
• Fixed several Access Violation errors
• Plug-In interface updated and documented

• New SQL Window preference: Show Dictionary Info In Result Grid:
• Column data type, optionality, and comment displayed
• Lookup for check constraints (col in (value1, value2, ...))
• Lookup for single column foreign key constraints to small tables with less than 1000 rows
• Added option to save backup files in a specific location
• Added Save & Load Object Selection to object grids (Export User Objects, Export Tables, Compare User Objects)
• AfterConnect.sql in PL/SQL Developer installation directory will be executed after connecting a session
• Hints & Warnings can now be cleared in Program Window
• Post Changes button in SQL Window is now disabled when there are no changes to post
• Export in Oracle Export format no longer deletes parameter file in TEMP directory
• Added PlugIn functions IDE_TabInfo() and IDE_TabIndex() to read and set Tab pages
• Connection Indicator Editor background did not work properly
• Excel interface did not handle formatting of numbers correctly
• PL/SQL Beautifier fixes:
• Caused error for multi-line string parameter values
• Did not format table list correctly in select statements
• Uppercase did not work properly for special characters
• Comments with unterminated strings would be incorrectly indented
• Object Type attribute declarations were not aligned
• Single line selection was not indented correctly
• Did not work correctly on Windows 9x
• Expressions in insert list items were not always formatted correctly
• Compiler Hint fixes:
• Record/object assignments could lead to incorrect unused value hints
• Nested if/then/else could lead to incorrect unused value hints
• Duplicate variable names in a program unit would cause unused declaration hint
• Variable names prefixed with program unit name would cause unused declaration hint
• Incorrect unused value hints when using variables after an exception
• Fixed several Access Violation errors
• Fixed some memory leaks
• Descending function-based indexes would show up ascending
• Find dialog: paste/cut/clear did not work when invoked for a read-only editor
• Copy to Excel did not handle duplicate column names properly
• Editor Special Copy fix Visual Basic: vbNewLine replaces vbCR
• Long (Raw) columns could not be queried when varchar(2000) or longer was included
• Code Assistant "overload" buttons were not always positioned correctly
• Original command-line parameters are now passed to New Instance (File menu)
• Leading and trailing spaces in table/column comments would be removed in Table Definition Editor
• Query Builder would cause AV on "Find Databse Object" Window
• Help button incorrectly appeared for non-Oracle error messages
• External Tools "Save Window" option was not stored

• PL/SQL Beautifier added
• Localization functionality added (Japanese version available, other languages will follow)
• Compiler Hints added for unused declarations, unused value assignments, comparison with NULL, function without return, and to_date without format
• Code Assistant can now use original case for inserted parameters, functions, and so on
• New Code Assistant preferences:
  • Describe standard functions (e.g. to_char)
  • Use original case if possible
• Backup and recovery options added for editor files
• Toolbar button options added for External Tools, Macros and Documents
• Copy to Excel added for SQL Window and Test Window result grid
• SQL Window preference "Date & Number fields to_char" split into 2 preferences
• Special Copy function to convert SQL to 3GL strings
• Command Window enhancements:
  • Support for WHENEVER SQLERROR | OSERROR added
  • Pause execution to single step through a script with command highlighting
  • SET EXECPAUSE ON | OFF added to control pause mode from script
• Report Window enhancements:
  • Export results to XML, CSV, TSV, or directly to Excel
  • System variables in report title (&dbuser, &database, ...)
  • Added Format option for number and date fields
  • Added LIBRARY parameter to select report style library file
  • SQL Text can be included in the HTML output
• Connection Indicator can now be applied to editor background or application background
• Export options for Statistics in SQL Window and Test Window
• Find Database Objects now also supports the Job object type
• Query button added to Table Definition Editor
• More robust Oracle Home selection
• Debugger preferences "Never/Always add debug info" now support connection matches (e.g. sys@*)
• Compare User Objects now ignores white space in PL/SQL source
• Support for Interval datatype added
• Timestamp and Interval datatypes supported in Export/Import table data
• Text Editor can now view text as formatted HTML
• Option in template to add brackets (using double brackets [[ or ]])
• Many other minor improvements and bugfixes

• Report Enhancements:
  • Page break added
  • New break option: Break + Header
  • Sum at break/report level added
  • Non breaking space option added
• Support for timestamp columns and attributes added
• Autorepeat buttons in SQL Window
• Key/Index column selector contained an empty entry for new keys/indexes
• Connection Match hint and right-click customization added
• SQL Window could give "list index out of bounds" in single record view
• Command Window did not always find files at preference location
• Added test for valid filename when creating new templates
• Printing Test Window with Page numbers would give two numbers
• Main Font preference now used in all dialogs
• Debugger could hang on startup (Initializing...)
• Table definition editor did not handle multi-line column comments correctly
• Code Assistant could popup after entering a command line in the command window
• Pressing backspace on the command line in the command window could erase prompt if Code Assistant was visible
• If a package or type specification was dropped, the body would remain visible in the Object Browser
• A quoted trigger owner in the trigger source would not correctly be recognized when opening it from the database
• Command Window did not handle comments in a string properly
• Ctrl-F4 from Text Editor closed parent Window
• Foreign Key References did not have table owner prefix in Object Browser

• Function-based index support added
• Test Window now supports Temporary CLOB's and BLOB's
• Average time column added to Profiler report
• New Appearance preference: Connection Indicators
• File > New Instance menu item added
• Job What PL/SQL Editor button added
• Job editor now accepts sysdate expressions for Next date field
• Command Window 'Edit' command now uses PL/SQL Editor
• When describing or Testing an invalid object, the object will now implicitly be validated
• && can now be used to escape substitution variables in SQL Window and Report Window
• If a trigger fails when posting a record in the SQL Window, the stack dump can now be viewed
• Register Filetypes Help button was missing
• Substitution variables are no longer processed for SQL Window with database source
• Fixed problem with column order when copying and printing some grids
• Profiler and Trace reports did not display trigger source lines
• Profiler report would incorrectly sort time columns if it includes a comma
• File > New > View menu item was missing
• Selections would not be visible when editor background is same as selection color
• External procedures and functions without a language were not displayed correctly in Code Contents
• Popup menu items in Plain Text Editor Window were not always appropriate
• Undo/Redo did not work in Plain Text Editor Window
• Create/Drop database link feedback in the Command Window was 'External database created/dropped'
• Improved handling of multi-line strings in Command Window
• Command Window pause command now supports a Cancel option
• Command Window set verify command did not always display variables
• Code Assistant did not work for aliases if select statement was in parenthesis
• Code Assistant is now disabled during Macro recording
• Sequence increment could not be negative
• Deferred constraints were read from dictionary as immediate
• Changing a the owner of a table did not propagate to the indexes
• View/Edit private database link did not retrieve password
• Editing a record in Single Record View in a SQL Window could lead to a partially updated database record
• If SQL tab page was not selected in SQL Window, "Cannot focus a disabled window" error would occur if an exception occurred during execution
• Cancel button in HTML Help Setup did not work
• Report Window Locking did not work properly
• Global private package variables were added to the Watch List with package prefix
• Compare User Objects: Target session logon now has history
• Templates: Positioning of cursor was not always correct
• Plug-In function IDE_CreatePopupItem did not work for Browser folder items (TABLES etc)
• Added Plug-In OnWindowCreate() and OnWindowClose()

• User's Guide provided as on-line help
• Popup menu with Copy and E-mail items added to Compilation Errors pane in Program Window and Compile Invalid Objects Window
• Fixed problem with assigning shortcut keys with Alt
• Fixed problem with substitution variable lists with a query bind variable that has more than one occurrence in the SQL Text
• Cut was not possible in Query By Example mode in SQL Window
• Functions involving table definitions could lead to 'not a valid integer' error
• Compare User Objects did not ignore index storage properties
• Printer initialization could fail during PL/SQL Developer startup
• Type owner and name could be changed when viewing an object table definition
• Right-click on an index in Explain Plan Window did not show index object popup
• Files associated with PL/SQL Developer did not always have an icon
• Command Window: define could not set empty values
• Plug-In interface: IDE_CreateWindow did not work correctly for all window types
• Object fetch performance improved of Export Tables, Export User Objects and Compare User Objects
• Filenames for Compare User Objects difference viewer now include username and database
• New Plug-In versions released: VCS 1.0.7 and PL/Formatter 1.0.3.

• Project concept added
• Reports added
• Export User Objects tool added
• Compare User Objects tool added
• Export popup menu item added for all grids (CSV, TSV, HTML & XML format)
• Export Plug-In functions added + RTF export demo Plug-In
• SQL Window improvements:
  • Single Record View added
  • Export Query function added (CSV, TSV, HTML & XML format)
  • Collection columns can be viewed
  • Support for substitution variables added
  • Support for Oracle9i XMLTYPE added
  • Linked Queries function added
• Test Window improvements
  • HTP Output will be displayed on HTP Output tab page
  • PL/SQL Trace support added for Oracle8i and later
  • 'Go to unit line' popup item added to Profiler Report grid
  • Can now be saved in SQL*Plus format
  • Test Script generation now determines named record types and PL/SQL Table types
• Command Window improvements
  • SHOW ERR*ORS [ObjectType ObjectName] command added
  • SQLPLUS command added
  • SET NUM*WIDTH added to set the maximum width of numeric columns (default 10)
  • Executes login.sql when started
• Code Assistant improvements
  • Context description added (object names & keywords)
  • Is now resizable
  • Does no longer pop up when typing comments or strings
  • Immediately completes name when started manually and only 1 option is available
  • Can be started manually for partly typed sub-object (e.g. dbms_output.pu|)
• Table definition editor improvements
  • Support for index organized tables added
  • Columns can now be dropped from an existing table (Oracle8i and later)
• Object Browser improvements
  • Drop item added to table column popup menu (Oracle8i and later)
  • Profiles folder added
  • Job folder added + Run item added for job popup menu
  • Database links folder added
  • Now allows you to select multiple objects
  • Drag and drop object popup (Name, Description, Properties, DDL, Call, Select, Insert, Update, Delete)
• Editor improvements
  • Column editing added (Cut, Copy, Paste, Delete, and Edit > Selection functions)
  • Tab and Shift-tab now indent and unindent
  • Syntax case highlighting improved during typing
  • Recall Statement function added
  • Oracle9i SQL and PL/SQL keywords added for syntax highlighting
• Profile definition editor added
• Job definition editor added
• Database link definition editor added
• XML Syntax Highlighting and XML validation added to Text Editor for CLOB's and VARCHAR's
• Oracle9i plan table columns added for Explain Plan Window
• Drag & Drop from Browser and Templates to Workspace
• Insert Template popup menu item
• New preferences:
  • Logoff with open transaction (Commit, Rollback, Ask)
  • Show complete file path in window titles
  • Appearance tab page
  • Database lists to always or never add debug info
  • SQL Window: Date & Number fields to_char
• Improved handling of ConnectAs logon option
• From User and To User options added to Import Tables function
• LogonHistory enhancements
  • More.. option with sort option
  • Display size preference to limit the number of displayed items
  • Reduce number of items (on startup) if History size was reduced
  • Display checkbox for active connection
• Tables and Primary/Unique Keys with referencing foreign keys can now be dropped after confirmation
• Size of all non-PL/SQL object editors are saved
• Save Layout now also works with maximized windows
• Command-line parameters added: NOSPLASH, NOLOGON, NOPLUGINS

• Connect as sysdba/sysoper did not propagate to secondary sessions. Therefore you could not connect as SYS when init parameter O7_DICTIONARY_ACCESSIBILTY=FALSE. This is the default setting for Oracle9i.
• Oracle Import and export did not work correctly with imp73 and exp73 on Windows 9X
• Explain Plan did not work for externally identified users
• Fixed installer "can't create..." problem
• Force OCI7 on OCI8 preference did not hide"Connect As" option in Logon Dialog
• Command Window did not spool dbms_output results

• Generating a test script for program units with non-scalar parameters would not include a declare
• Picking a connection from a logon history without password and canceling would lead to an inconsistent situation
• Pressing the Parse button in Query Builder for an empty query would cause an Access Violation
• Removed Read Only option from Open File Dialog in Query Builder
• Fixed "Index out of Bounds" when deleting selected Browser Filter
• Enhanced Plug-In interface (IDE_Perform and OnMainMenu)
• Fixed "List index out of bounds (0)" during editing with Code Contents
• Browser Preference "Confirm Recompile" added
• Session Queries optimized: execution delayed until page is displayed
• Paste did not work in result grid of SQL Window in QBE Mode
• Reload in Program Window could lead to access violation
• In multi-session mode, NLS_DATE_FORMAT would be DD-MON-YY on some systems
• Escape possibility ($$) added for templat variables (e.g. $$DATE => $DATE)
• Adding a table from an other owner did not work correctly in Query Builder
• Result set in SQL Window was read only if multiple SQL statements were present in the editor
• Statements were not correctly separated in SQL Window if it ended with ); e.g. in (1,2);
• Add debug information for package and type specification now implicitly adds it to body
• Default file extensions were not applied in import / export functions
• Fixed problem with Plug-In function IDE_GetBrowserItems()
• Command Window could hang during execution
• Program Window title was not always kept up-to-date
• Export function could give error message "File plsexp.log could not be opened"
• Memory usage optimized in Find Database Objects function
• Added Cursor Home & Cursor End buttons in Find Dialog
• Default templates are loaded from default directory when not found in user defined directory
• Fixed printing problem with wrong second pages on some printers
• Fixed problem with printing Explain Plan Window twice

• New Tools
  • Import Tables
  • Export Tables
  • External Tools
  • Event Monitor
  • Sessions
  • Query Builder
• New object definition editors for
  • User
  • Role
  • Library
  • Directory
• Plan Window Enhancements
  • All plan table columns can be selected
  • Optimizer goal can be changed
  • You can step though the operations in order of execution
  • Object popup added for 'Object name' column
  • Plan table cleared after execution
• Browser Enhancements
  • Users now have an Objects folder
  • Tablespace and Cluster folders added
  • Recent objects folder added
  • Preferences page added (Folders, Maximum recent objects, Double-click action, Show datatypes)
  • Function, procedure and method parameters can be displayed
  • Attributes and columns of object types can be recursively expanded
  • Methods can be described
  • Methods can be tested
  • Libraries folder added
  • Directories folder added
  • Filter button added
  • Filters can now be user-specific, with a default filter for each user
• SQL Window enhancements:
  • Query By Example mode
  • Configurable shortcut keys for buttons
  • Result set supports object types
  • Result set supports nested cursors
  • Check for lock before updating or deleting a record
  • Window title generated from SQL text instead of 'New'
  • Selected statement will be executed
• Test Window enhancements
  • PL/SQL Profiler added for Oracle8i and later
• Debugger enhancements
  • Collection element items can be displayed e.g.: Employees(index).Name
  • Collections of scalar datatype can be viewed
• Command Window enhancements
  • SET COLWIDTH added
  • SET SCAN added
  • Object commands added (RECOMPILE, VIEW, EDIT, PROPERTIES, QUERYDATA, EDITDATA, EXPORTDATA, TEST, and BROWSE)
• Program Window enhancements
  • Java source support added
  • PLS-00323 and PLS-00538 handled smarter
• Code Contents enhancements
  • Code Contents selection now keeps track of cursor position
  • Select item added to contents popup menu for functions and procedures
• Object definition editor enhancements
  • Now shows creation SQL if no modifications were made
  • SQL can be opened in Command Window
• Table definition editor enhancements
  • Object table support added
  • Temporary table support added
  • Column types left aligned in create table SQL
  • Object popup added for foreign key referencing table
• Code Assistant enhancements
  • Support for object type constructors
  • Support for object type variables
  • Support for object type columns
  • Support for standard collection methods (first, limit, ...)
  • Support for collection element object types
  • Support for %rowtype variables
• Editor enhancements
  • Uppercase/Lowercase/InitCaps keyword syntax highlighting
  • Apply syntax case to editor selection
• Plug-In enhanced (see Plug-In documentation for details)
• HTML Help enhancements
  • "Stay On Top" preference added
  • Search-delay implemented
  • Find function added to Internal HTML Viewer
• Find Database Objects now supports all object types
• Oracle Home preference added
• Check added on first startup for multiple oracle homes, and automatically select a valid home
• Holding down the Control key during Logon prevents that the connection is saved in the logon history
• Configurable Toolbar buttons
• New disabled Button style (only 32k color or better)
• New Info button on About screen
• New and improved installation procedure

• Fixed "get_scalar: exception 10" and "backend error 1003" error messages in trace file during debugging
• Main window could become invisible as result of "Autosave Desktop" preference
• Internal HTML Viewer still required Internet Explorer ("Class not registered")
• HTML Help did not use context when activated for the first time
• Hyperlink Navigation caused Access Violation when Code Contents was not used
• Fixed occasional "Control has no parent window" error messages

• Added Oracle8i keywords for syntax highlighting
• HTML Help is now compatible with IE 5.5
• View/Edit for a view created by other user did not include column alias
• Fixed Code Assistant related hang-up in Program Window
• Fixed "List index" error when reloading a changed Program File with more than 2 programs
• Fixed "Control has no parent window" error in Table Definition Editor
• Fixed delayed effect of font color preference in Template List
• Improved 'default extension' behavior when saving files
• Fixed AV's after an object has dropped with reference folders opened
• Improved printing of (Auto column size) grids
• Improved copy from grid when first cells are empty

• Added an internal HTML Viewer for users without Internet Explorer
• Added a 'Use internal HTML viewer' preference
• Debugger can now set and view private global variables (declared in package body)
• Plug-In interface IDE_SetFilename added to change filename
• Plug-In interface IDE_Splash added to hide Splash screen

 Bugfixes

• Toolbar buttons were not up to date after creating a new view
• Command Window could sometimes lock up when using commas in some commands
• Plug-In function IDE_RefreshMenus did not keep ShortCut keys active
• Fixed problems when connected as externally identified user (e.g. explain plan)
• Select statements could sometimes lock up Command Window on Windows 2000
• Fetching next page in SQL Window with modified results could result in 'ghost records'
• Large Cost & Cardinality values could lead overflow error in Plan Window
• If a table and trigger had the same name, a describe would result in ORA-01422
• Corrected 'Type' and 'Type body' templates (no name after end)
• ErrorList in Program Window did not always show scrollbar
• Test Window debug button would get enabled in Single Session Mode after an error
• Test Window watches and callstack buttons were always enabled
• Code Assistant would not work for parameters after 10 lines
• Column defaults would sometimes be displayed with garbage characters

• Added a background color preference for Editor, Browser and Grids
• Added Date/Time dropdown in Test Window for date variables
• Delete word function made available as hotkey
• Added Confirm Commit & Rollback preference
• Added Commit on Post preference for committing posted records in SQL Window
• Holding down Ctrl while pressing the Post button will now implicitly Commit

 Bugfixes

• Uppercase/lowercase or comment/uncomment affected readonly editors
• Long & Cursor variables didn't get value cell in 'Test' function
• Precision and Scale were swapped in type attribute description
• Float columns were displayed with precision
• Alt-hotkeys in popup menus would cause a 'beep'
• Quoted variable values in Command Window would include the quotes
• Tablename not recognized when right-clicking on "delete <tablename> where" statement
• Empty programs would lead to error message when compiling a Program Window
• View function for Tables, Sequences and Synonyms would always create a new window
• SQL error locations are now correctly displayed on Net8 8.0.5.
  (On 8.0.3 and 8.0.4 error locations are not reported)
• LOB variables could not be used in Test Window in Multi Session Mode
• VCS Plug-In did not work correctly with ComponentSoftware RCS

• Breakpoint conditions and messages
• Drag & Drop capabilities from Description/Properties Window to Editor
• Popup menu in editor margin with Bookmark and Breakpoint function
• Comment and Uncomment functions in Edit > Selection menu
• Comment text feature for templates
• Added (more...) to status line when more records are available in a SQL Window
• Next & Last Page items in Grid popup menu in a SQL Window
• Move, Insert & Delete variables in a Test Window
• Store Window List Short Text preference during Save Layout
• Align Grid item in Editor popup menu in a SQL Window
• Several Plug-In interface enhancement for the new Version Control Plug-In

 Bugfixes

• Grid printing would fail after first page on some printers
• Set Breakpoint menu item would set Bookmark instead
• Access violation with popup menu on empty editable result grid
• Userid parameter did not work
• Selection would grow when case-changing selection with multiple lines
• Fixed some template issues
• Trailing '/' would sometimes unnecessarily be removed from a template
• Query results in a descriptive list in a template did not work properly
• Template could not handle * for default values in checkboxes
• Feedback limit would affect Insert, Update & Delete in a Command Window
• Default extension for @ command did not work properly in a Command Window
• Fixed some copy & paste issues in grids
• Next Page & Last Page in SQL Window did not work in single session mode
• Table editor could not handle indexes with the same name as a foreign key
• Optimized save function to store CSV file in SQL and Test Window
• Text in grids would ignore character set of selected grid font
• Width for numeric column formats in Command Window was not correct
• Test Window could not be closed if session was killed

• Code Navigation through Code Contents, Hyperlink Navigation and Browse back / forward buttons.
• New hierarchical Template Window with more powerful template format, the ability to insert template code into existing source code, and more.
• Create, drop, view, edit, and rename any object from within PL/SQL Developer, including tables, constraints, indexes, privileges, sequences and synonyms.
• A new Window List to easily navigate between multiple document windows.
• Command Window now has a built-in script editor with appropriate syntax highlighting, supports bind and substitution variables, and supports many new commands. Error locations are highlighted.
• Test Window now supports Long, Long Raw, BLOB, CLOB, BFile and cursor variables, and also supports Long, Long Raw, BLOB, CLOB and BFile fields in the result grid.
• SQL Window can now incrementally fetch results. Rows in the result grid can be locally sorted. Numbers are automatically formatted.
• Object Browser can now recursively expand objects. Triggers and constraints can be enabled and disabled. Drag and drop object names into editors.
• Code Assistant can now recognize table aliases for select, update and delete statements, can describe users and synonyms, and can be activated manually.
• Context sensitive object popups: only items appropriate for an object will be displayed (e.g. "Query data" for a table or view).
• Logon history with or without password can be maintained for easy logon.
• Editor syntax highlighting improved, new "Find matching pair" function, bookmark improvements, mouse wheel navigation improved.
• And much, much, more...

• Separate print buttons in the toolbar for portrait and landscape
• Black/White printing preference added
• Fixed problem with missing line between printed pages
• You can now also print the output page of a SQL Window or Test Window
• Added print option to description & properties window
• The result grid in the SQL Window now resizes when the window is resized
• The SQL Window now also stores statements in the history buffer that are not yet executed
• Cut, Copy & Paste keys did not work in the Text Editor for Long columns in the SQL Window
• Fixed problems with comments and empty lines between 'create or replace' and the object type and name in the Program Editor
• Role granted to users displayed role granted roles in the Object Browser
• Commands in the Command Window were not recognized if followed by a tab character
• Command Window did not update the break, commit and rollback button after executing a pasted command
• Debug functions are now disabled in single session mode
• Main Window could sometimes disappear on Windows NT with 'Autosave Desktop' preference
• The 'Wrap lines' preference has been disabled, which caused problems with debugging and compilation errors
• Integration with our Direct Oracle Access components for Delphi and C++Builder
• Added results to TestWindow for Direct Oracle Access integration
• Oracle_Home would not be detected if the Home directory is not in the PATH
• SQL*Net in incomplete Multiple Oracle Home could not be initialized
• Some Plug-In enhancements

• Oracle8i related enhancements
  • Support added for Net8 8.1
  • Support added for Multiple Oracle Homes and the Oracle Home Selector
  • The parse error position, which is missing in Net8 8.0, is now supported for Net8 8.1
• Debugger related enhancements
  • You can now view and set public global package variables on 8.0.5 and later
  • The call stack now displays the program unit name for each frame on 7.3.4.3 or 8.0.5 and later
  • Double-clicking on a call stack frame now navigates to the source line on 7.3.4.3 or 8.0.5 and later
  • Cursor status (rowcount, open, found, notfound, ...) displayed in variable value pop-up
• Other enhancements
  • Selecting 'Test' in the Object Browser for overloaded program units now allows you to select a specific overloading
  • The 'Edit' menu option in the Object Browser is now enabled for updateable views
  • In the Object Browser you can now view the triggers defined on a view
• Bugfixes
  • The icons in the Object Browser were invisible on systems with an older version of comctl32.dll
  • Newly recorded macros could only be assigned to a hotkey after restarting PL/SQL Developer
  • When the package state was discarded during a debug session, the debugger would sometimes crash
  • The debugger variable value pop-ups would sometimes "stick" on the screen

• Occasionally a Program Window would become extremely long after opening a file
• Access Violation when closing a maximized Test Window
• Ctrl- or Alt-key combinations could not be assigned to a macro
• Scan button in Test Window would find variables in quoted strings
• A new Code Assistant Style preference is provided, which controls how the Code Assistant inserts identifiers into the source code: Init Caps, Lowercase, Uppercase or Smart (default).

• Integration with Oracle HTML manuals
• User-defined shortcut keys for all functions
• Users, Roles, Synonyms and Object privileges added to Browser
• Refresh button in Browser now only refreshes the selected object
• Save Desktop preference added
• Explain plan is now displayed as a tree with descriptions in the status line
• New Directories preference added
• New editor preference: allow cursor after EOL
• Print selection added
• File association dialog for confirmation & manual selection
• Plug-In interface implemented (Documentation available on request)
• Several 2.0 bugfixes and improvements

• Multi threading / Multi session environment
• Oracle8 feature support (Types, CLOB's, BLOB's, BFILE's)
• Integrated Debugger
• Template Library
• Browser Filters
• Command Window
• Compile Invalid Objects function
• Find Database Objects function
• Code Assistant
• Macro Library
• Many Editor improvements
• Many Browser improvements
• Many new preferences
• And much, much, more...