Bug Fixed since Oracle SQL Developer 1.2.1 was released on 22 August 2007.

This list is not all-inclusive. Since August 2007, the SQL Developer team have closed over 950 (1370 includes "not a bug to filer" ) bugs. Many of these are picked up as the developers are working with the product and range from trivial to more complex issues. This list is a selection of higher priority bugs, customer bugs in Metalink and a selection of those reported by the community on the forum.

• General
  • Bug 6619047: Schema diff does not give output when comparing entire schema
  • Bug 5027616: Autocomplete does not support mixed case tables
  • Bug 6441868: Cant open multiple sql worksheets
  • Bug 6956419: csv data with dates cannot be loaded into sqldeveloper
  • Bug 6839320: Manage database closes connection
  • Bug 6840367: SQL Dev irrecoverable crash when workign with oem
  • Bug 6902581: Import data: sql script generated for non-english locale fails.
  • Bug 6737617: Only views from sys schema displayed in extended search when type is view
  • Bug 6079959: ora-01000 maximum open cursors exceeded while copy oracle schema
  • Bug 6617962: Preferences - file types throws error
  • Bug 6619047: Schema diff does not give output when comparing entire schema
  • Bug 6614760: Selecting the type as all not displaying any values in extended search.
  • Bug 6398350: SQL Developer load issue due to odjbc4.jar
  • Bug 6273949: sqldeveloper.exe does not work with jdk installed in win64 oracle_home
  • Bug 6734128: sqldeveloper process is running background after being closed
  • Bug 6046813: vista only: check for updates hangs when stop button clicked.
  • Bug 6784650: diff wizard creating script with unncessary nulls
  • Bug 6812859: Column names missing in drag and drop of view
  • Bug 6843882: My documents in open/save file dialog invalid for vista
  • Bug 6805109: Extended paste doesn't work from edit menu, only via crtl+shift-v
  • Bug 6784232: Extended search : type list has multiple entries of all
  • Bug 6907538: Import data - date column could not be imported
  • Bug 5922434: Problem with externally modified prompt and packages
  • Bug 6614612: Table details are not displayed when clicked in extended search.
  • Bug 6784632: Tools > diff wizard causing ora-01000 maximum open cursors exceeded
    
• Browser
  • Bug 6156238: Certain pl/sql causes modules not to display in expanded tree view of package.
  • Bug 6059492: Functions (copy paste find) on edit menu disabled
  • Bug 5864942: clear filter on tables means synonym checkbox is lost
  • Bug 6145625: nlsutil does not handle "timesten" database gracefully
  • Bug 6362167: ora-31603 error when you browse objects that you do not own
  • Bug 6817229: Changing the index name, displays error when advanced option is selected
  • Bug 4948496: Edit table dialog: sdo_geometry type displayed as simple, should be complex
  • Bug 5871246: Object navigator node expanding performance for apps
  • Bug 6059492: Functions (copy paste find) on edit menu disabled
  • Bug 6085068: Dependencies tab not showing fk relationships for tables
  • Bug 6326563: Check granted objects get "table or view doesn't exist" error
  • Bug 6328865: create a table with xmltype column > browse storgae option >fails
  • Bug 6331905: export data > txt resulting in a file without data
  • Bug 6334819: revoke privileges causing exception
  • Bug 6338689: procedure > export ddl > save to file not creating file with extension
  • Bug 6436084 apply filter on existing sort dialog
  • Bug 6511487: Like filter does not find exact match
  • Bug 6658634: Precision and scale fields are reversed in add column dialog
  • Bug 6673623: clicking flashback tab for a table on a 9.2 db gives ora-00942
  • Bug 6686385: Schema diff report. detail syntax output report gets lost
  • Bug 6696926: Browse preferences > database > general export parameters - failed
  • Bug 6813824: Apply filter on java node does not show the filter dialog.
  • Bug 6814244: Cannot expand mat view node to view columns
  • Bug 6816824: Sort on package elements not implemented
  • Bug 6836802: Sort on connections is case sensitive - all lower case connections last
  • Bug 6866540: Diff wizard - could not diff indexes
  • Bug 6884652: Browse tools > preferences > accelerators - fails
    
• Connections
• Bug 6061329: Problems with parsing comments ending in ) tnsnames.ora
• Bug 6408435 add or delete connections messes up db object search view
• Bug 6438505 additional database connections with null values are dispplayed in sqlworksheet
• Bug 6933463 cannot set a tns_admin in registry for tnsnames.
• Bug 6709785 sql developer can't create connection on windows desktop
• Bug 6836296 mac:new connection dialog too small for connect button
• Bug 6837457 Changing connection on worksheet does not change title bar
• Bug 6781866 export connections should be sorted alpha numerically, currently export is mixed
• Bug 6623327 invalid userenv parameter error thrown on opening a 9i oracle db connection
• Bug 6636149 tns names are displayed twice in network alias drop down
  
• Create and Modify
  • Bug 6160491: Creating table comments using parameters is not possible in sql dev through ddl
  • Bug 6326721: Updatable views - could not insert, update and delete as for tables
  • Bug 6504531: object_owner is expected for 'compile invalid' sql
  • Bug 6867742: Users with parmission select any dictionary cannot view trigger details
  • Bug 6771396: Schema diff adds in "null" for alter table statements
  • Bug 6828128: Cannot create objects in other schemas
  • Bug 6082981: Cancel running copy schema dialog, freezes sql developer
  • Bug 6493288: Can't select columns when create advanced view
  • Bug 6691998: Can't switch to advanced mode immediately when creating indexes
  • Bug 6338651: Create function / procedure : code editor not launching
  • Bug 5714824: Database links > new database link - error for duplicate name
  • Bug 6165283: Editable with uk named as <table>_pk hangs when primary key tab is selected
  • Bug 5691311: Privileges can be granted but cannot be revoked
  • Bug 6660121: NLS: comment is not verified according to db characterset
  • Bug 6880066: Table >column > add - error when scale or precision is null
  • Bug 5639689: There is no place in dialog to create partitioned indexes
  • Bug 6326721: Updatable views - could not insert, update and delete as for tables
  • Bug 6832227: Diff wizard > diff two tables with different comments - the diff count is zero
  • Bug 6807195: Copy wizard does not copy queue tables or nested tables
  • Bug 6600948: Hindi multi-byte data cannot be imported from excel
    
• SQL Worksheet
  • Bug 6444547: Duplicate trigger entries on table definition's "trigger tab"
  • Bug 6836048: Single record view incorrect after changing column order
  • Bug 5766317: Time not displayed correctly because of daylight saving time
  • Bug 6002713: Describe table@db_link gives an error that the object does not exist
  • Bug 6752458: Autotrace fails to retrieve plan for long sql statements
  • Bug 6752458 autotrace fails to retrieve plan for long sql statements
  • Bug 6689581 can't connect as sysdba with tns connection in worksheet
  • Bug 6741406 regression: no feedback displayed to screen when running script
  • Bug 6814673 substitution vars expanded in comments
  • Bug 6156468 sys_context returns null for 'userenv'
  • Bug 6354519 set serveroutput on command and dbmsoutput tab are not in synch
  • Bug 6415080 '--' taken as a single line comment rather than a string on searching for binds
  • Bug 6369975 date field editor is not consistent for some nls formats.
  • Bug 6314230 desc does not work in subscripts i.e. @runthisfile.sql
  • Bug 5716856 describe table inconsistent using f4 and right click
  • Bug 6797209 Row count feedback seems to have disappeared
  • Bug 6807083 Changing connection on worksheet does not change the tab name
  • Bug 6813314 Running describe statement scrolls to top of worksheet
  • Bug 5592534 embedded cursor in select statment fails - works in sql*plus
  • Bug 6436296 history allows multi-select, with append /replace doesn't work
  • Bug 4968641 nls_date_format session parameter not used in printing dates
  • Bug 6316218 q function fails in sql developer
  • Bug 6733993 run sql in sqlworksheet cause status to modified, and ask for save when close
  • Bug 6315841 scroll-to-line for run script/f5 is not consistent
  • Bug 6913563 select '-- title --' from dual does not work in worksheet
  • Bug 6494839 set escape select 'test1&test2&test3' from dual;
  • Bug 5166902 sql history - brings back command with ; appended, this makes pl/sql fail
  • Bug 6888568 status bar message from worksheet not showing correctly
  • Bug 6390177 when you resize a column, it always naviagtes you to the top of the grid
  • Bug 5455865 worksheet's results table shows context menu not applicable there
    
• Data
  • Bug 6798494 Edit table > add column > data cannot be added to the new column
  • Bug 6898448 import data - could not edit the datatype
  • Bug 6737049 moving columns in data tab of a view cause header and data mismatch
  • Bug 6877799 right click select duplicate row in data tab, commit & rollback are not enabled
  • Bug 6329008 date field doesn't work well when change preferences
  • Bug 6836048 single record view incorrect after changing column order
  • Bug 6159559 exception opening a table containing long raw datatype for the first time
  • Bug 6898423 import data - column missed
  • Bug 6813901 import from xls-data, all columns and all rows, into a table with data
  • Bug 6766821 newly added column is not displayed for sorting in the data tab
  • Bug 6021950 no means of getting to the last records in sql worksheet - page down fails
  • Bug 5331012 results grid - only shows 5 digits even when 100,000+ rows displayed
  • Bug 6707127 sort function miss columns
  • Bug 5710582 NLS MySQL: mb column name cannot be shown
    
• PL/SQL
  • Bug 5232298: Euro character not displaying correctly in sql developer
  • Bug 6615274: Collapse declerations/bodies in pl/sql code editor not working.
  • Bug 6887068: Cannot find block source when debugging
  • Bug 5695015: Focus lost from the code window after clicking debug
  • Bug 6046191: Remote debug in vista - short key "step over"(f8) doesn't work
  • Bug 6162631: Smart window not displaying results
  • Bug 6759023: Debug breakpoints can be off by 1 line, test case here
  • Bug 5397988: File based pl/sql handled very differently to database loaded code
  • Bug 5531646: Problem viewing cursor value in debug mode
  • Bug 6798112: Memory hog on plsqlparsers
  • Bug 6086801: Anonymous block script, can load file, but can't save it.
  • Bug 6326963: Give plsql file new extension, file neither opens in plsql editor nor sql editor
  • Bug 6785834: Code completion suggestion list should be unaliaced in the alised context
  • Bug 6802484: Package decomposition does not show types, cursors, variables/constants
  • Bug 6866099: Collapase/expand procedure declarations/bodies issues
    
• Preferences
  • Bug 6836510: Add new files types throws error
  • Bug 6836886: Code editor: save actions throws error
  • Bug 6880598: Error when accelerators clicked
  • Bug 6342176: Preferences > migrate settings failed on most settings in linux
  • Bug 6859498: Database > nls parameters, save wrong date format causes exception logs
  • Bug 6405988: Provide preference to allow users to warn to save before closing tabs
    
• Migrations and Third Party
  • Bug 6199952: SQL Developer migration workbench does not migrate ms access default values corr
  • Bug 6329217: MySQL v5 primary keys not migrated using SQL Developer
  • Bug 6520888: Migration MySQL to oracle using sql developer 1.2 failed.
  • Bug 6372467: Quick migrate without repository, repository is not removed after completion
  • Bug 6329217: mysql v5 primary keys not migrated using sql*developer
  • Bug 6345393: cannot edit views, functions, triggers or procedures in the migration models
  • Bug 6372521: ms access models unnecessarily available for gerating data move scripts
  • Bug 6389880: column default value cannot be added or modified for table in converted model
  • Bug 6392294: sqlserver online 2005 foreign keys not loaded
  • Bug 6460973: indexes in empty tables not captured
  • Bug 6645154: NLS migration: garbled mb colname in captured/converted objects
  • Bug 5954215: SQL Server connection, save password unchecked still displays password.
  • Bug 6359570: Quick migrate: no way to change repository connection being used
  • Bug 6365913: Offline data move > sqlserver - error for categories and employees table
  • Bug 6372467: Quick migrate without repository, repository is not removed after completion
  • Bug 6438874: Access offline data move '[' mismatch in exporter/sqlldr scripts
  • Bug 6717311: Captured microsoft access modules: display name shouldn't include filepath
    
    
• Import and Export
  • Bug 6817124: Import data unable to import date using XLS
  • Bug 6877485: Export wizard, in searching progress window click cancel, message displayed
  • Bug 6817208: Error displayed when importing data on selected columns & all rows into table
  • Bug 6749731 Export data grid to insert statement adds extra value "row", script fails
  • Bug 6759253 Export data in wizard omits column, insert fails, number of values mismatch
  • Bug 6836751 Export wizard, export to file large table >300000, or many objects fails
  • Bug 5847984 Export ddl - duplicate entries for indexes
  • Bug 6615410 Export ddl: select 2 tables to export & select drop statement, drops all tables
  • Bug 6814536 Export wizard date data goes to timestamp
  • Bug 6727617 Importing excel data with single quotes , does not escape the quotes
  • Bug 6610273 Importing from excel not all decimal points migrated
  • Bug 6078557 Wrong decimal separator when importing data from xls
  • Bug 6759230 Export order for tables changes depending on how the wizard is used
  • Bug 6804864 Export wizard excludes pk constraints for table with only 1 constraint
  • Bug 6853931 '(clob) ' text incorrectly included in export data for a clob column
  • Bug 6315836 Export > insert - should not wrap the table name in double quote
  • Bug 6436278 Export bigger tables (with 300,000 rows) to csv
  • Bug 6067387 export for some tables includes null insert row
  • Bug 6730107 export tables with dependencies does not export unique indexes
  • Bug 6658087 export to loader, xml and insert fails for mdsys.sdo_geometry
  • Bug 6962299 on 'insert' style export of table data nls used i.e. (1,2) instead of (1.2)
  • Bug 6960117 spanish characters are garbled on data grid export->data->insert-> to clipboard
  • Bug 6732587 sql loader export fails to create correct syntax
  • Bug 6399733 table > export data - only export filtered data
  • Bug 6798539 table > export ddl > save to html not possible
    
• Reports
  • Bug 6844271 Report execution time is always 0ms
  • Bug 6176623 Go to menu on pl/sql source code, does not go to line of code, but to top
  • Bug 5613002 printing is not scaled correctly for reports
  • Bug 6344609 refresh rate for reports changed to 5 seconds is not displaying reports
  • Bug 6832397 reports > go to option not working for materilized view
  • Bug 6340329 reports on constraints does not have go to <table name> option