Contents

1. New Features
2. Bugs Fixed

New Features

• Click through mechanism for Synonyms now available. i.e., Using the Object Filter, you can include synonyms for tables under the Tables node and click to select the underlying data and structure.
• Global search has been implemented. This will find objects wherever they are in the schema and will also span users and schemas.

Bug Fixed in Oracle SQL Developer 1.1

• Performance
  • General Navigator performance issues addressed.


• General
  • General UI inconsistencies addressed.
  • Bug 5688278: TASKBAR DOES NOT SHOW AN ICON ANYMORE
  • Bug 5692906: SETTINGS FROM PREVIOUS RELEASE NOT MIGRATED
  • Bug 5722051: EXTERNAL TOOLS MENU AND DIALOGS SHOULD SUPPORT MACROS


• Browser
• Bug 5211229: CANNOT VIEW DATABASE OBJECTS LIKE PACKAGES W/ USER W/O CREATE OR EXECUTE PRIV
• Bug 5711038: SYNONYMS IN TABLE FOLDER HAVE NO DDL
• Bug 5711051: SQL TAB ONLY SHOWS CREATE TABLE DDL, NO LONGER COMMENTS OR INDEXES


• Create or Modify Objects
  • Bug 5046130:CREATE TABLE: CAN GET STUCK IN AN INVALID STATE IF TABLE TYPE CHANGED
  • Bug 5581738: SAVE AS PL/SQL CODE OVERWRITES EXISTING CODE WITH "NULL"
  • Bug 5596377: ABILITY TO SEE OTHER SCHEMA PACKAGES CODE WITHOUT EXECUTE PRIVS
  • Bug 5714778: SYNONYMS > NEW SYNONYM - CREATE SYNONYM NOT WORKING


• PL/SQL
• Various remote debugging issues addressed.
• Bug 5635550: IN CODE EDITOR DRAG-DROP DOES COPY INSTEAD OF MOVE
• Bug 5713984: SAVE AS NOT WORKING PROPERLY FOR PACKAGE SPEC AND BODY WITH EXTENSIONS PKS & PKB


• Connections
  • Bug 5748091: SQL DEVELOPER 1.0.0.15 DOES NOT USE TNS_ADMIN IN THE WINDOWS REGISTRY
  • Bug 5839859: TNSNAMES FILE IS CASE SENSITIVE - UPPER CASE TNSNAMES FILE NOT FOUND


• Data
  • Bug 5485216: MOVE OR DRAG COLUMNS GENERATED INCORRECT UPDATE STATEMENT
  • Bug 5711442: DECIMAL SEPARATOR IS USED FROM LOCALE NOT FROM DECIMAL SEPARATOR PREFERENCE


• Import from Excel
  • Various import issues have been addressed.
  • Bug 5707730: Multi Byte CHARS ON EXCEL IMPORT INTO TABLE DIALOG ARE GARBAGE
  • Bug 5711843: TABLES > IMPORT DATA > EXCEL - NO ERROR IF SYNTAX IS WRONG
  • Bug 5762255: ALL DATA FORCED TO LOWER CASE IN EXCEL IMPORT


• Export DDL
  • Various Export DDL Index related bugs fixed.
  • Bug 5847974: DUPLICATE ENTRIES FOR INDEXES
  • Bug 5841381: EXPORT ONE TABLE AT A TIME CAN PRODUCE AN EMPTY FILE


• SQL Worksheet
  • Bug 5027616: AUTOCOMPLETE DOES NOT SUPPORT MIXED CASE TABLES
  • Bug 5716306: TABLE AUTOCOMPLETE NOT LONGER WORKS ON CTRL ENTER IN SQL WORKSHEET


• Third Party Database Support
  • Bug 5755130: MYSQL DB CHOICE NOT USED IN URL FOR MYSQL CONNECTION
  • Bug 5755167: MYSQL PROCEDURE VIEWER DOES NOT SHOW PARAMETERS


• 8.1.7 Database Support
• Bug 5705849: CAN'T RUN PL/SQL PACKAGES


• NLS Support
• Bug 5613754: DEFAULT LANG AND TERRITORY NOT EQUAL TO OS LOCALE


• Query Builder
• Bug 5634385: LOGICAL OPERATORS UNDER WHERE CLAUSE IN QUERY BUILDER IS NOT LISTED NOT PROPERLY
• Bug 5695278: LIST OF TABLES SHOULD OFFER A FILTER
• Bug 5751752: SEARCH IN QUERY BUILDER IS NOT WORKING