PL/SQL Developer 6 所有的发布日志(截止2005-03-18)

Enhancements in PL/SQL Developer 6.0.5
======================================
* 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]

Enhancements in PL/SQL Developer 6.0.4
======================================
* 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

Enhancements in PL/SQL Developer 6.0.3
======================================
* 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

Enhancements in PL/SQL Developer 6.0.2
======================================
* 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

Enhancements in PL/SQL Developer 6.0.1
======================================
* 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

New features in PL/SQL Developer 6.0.0
======================================
* 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
  > noplugins: don't load Plug-Ins