plsqldev6(oracle数据库图形化管理工具)

PL/SQL Developer 6.0.3 ====================== Installation ============ To install the software, simply run the included executable. It will ask you for the product code that you have received from us. After this, all files will be copied to a temporary directory and the setup will be started. If you are currently using a previous version of PL/SQL Developer, you do not need to uninstall it. The setup program will replace all existing files. 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 wo