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