Contents

1. New Features
2. Known Issues
3. Accessibility Issues
4. Globalization
5. Other

1.  New Features

• Connections
• Object Navigator
• SQL Worksheet
• General
• Reports

1.1  Connections

Connections	Can now Save connection without closing dialog
	Creating Connections Dialog updated
	Save an "empty" connection
	TNS connections don't expand out
Third Party Access	Read-only connections added:   - MySQL   - SQL Server   - MS Access

1.2  Object Navigator

Browse Objects	Allow sorting through column headings
	Extended filtering:   - Multiple filter options and criteria   - Incorporates AND or OR filtering (All or Any selections)   - Filtering on other users includes OBJECT_COUNT to filter out users with no visible objects
	Increased Details Tab information. Display Create Date and last DDL for all objects
	Increased search capabilities
	Updated Object Navigator for improved object browsing and navigation
Column Sequences	Add sequences with triggers for any column. (In addition to adding sequences with triggers for Primary Key)
Database Links	View public database links
Directories	View details
Domain Indexes	Create an index on any existing index type from any accessible schema
Materialized Views	Advanced checkbox   - Define the Select statement declaratively by choosing select items, from objects etc   - Add indexes   - Add partitions
	Add indexes for Materialized Views using "New Index"
Materialized View Logs	New interface for creating and editing Materialized View Logs
Messages	Updated Error Display to show more specific to Oracle errors
	On Compile, display a success message in the status bar
PL/SQL	Added line number toggle to read-only code view
	Compile all invalid objects
	Compile all
	Default skeletal implementation from the spec for "Create Body"
	File based PL/SQL support   - Open, edit and save pl/sql files   - Compile pl/sql file against schema to update database
Sequences	Right-click context menu to alter sequence
Tables	Browse data (with XMLType columns)
	View CLOB data
	Disable related FK constraints
	Enable related FK constraints
	Triggers tab in master/detail format. Detail displays trigger code
Users	Create user with grants and roles etc
	Edit user roles, grants and privileges
Views	Compile Invalid
	Update data in updatable views
XML Schema	Read-only support for XML Schema

1.3  SQL Worksheet

Data Grids	Added duplicate record button
	Added single record "pivot" to view and edit one record at a time
	Allow columns to be reordered in SQL Worksheet and recall previous order
	Calendar prompt for date fields in table data editor
	Context Menu on grids
	Count Rows with filter
	Improved data grid navigation
	Auto resize column widths (on context menu on the data grid and column header)
	Copy any selection and paste it anywhere else in the grid
	Copy and paste the selection into Excel
	Copy a selection from Excel and paste into the data grid
Query Builder	Create basic query
	Run query to test data
	Transfer SQL to SQL Worksheet
Snippets	Create new category
	Create new snippet
	Make Snippets manageable by the user, edit snippets
SQL Worksheet	Added BLOB support in SQL Worksheet and Reports
	Added file browsing support
	Additional SQL statement formatting in the SQL Worksheet
	Allow for report and form view of SQL query results in the worksheet
	Bracket matching support
	Better support for displaying output of ref cursors
	CLOB, xml, cursor support
	Code insight on table alias
	Describe a table using a short cut key
	Refine tab names: Set worksheetname 'MyTab Name'
	Ongoing expansion of SQL*Plus support (See list below)
	Pause long running script
	Resume paused script
	Select entire row by selecting rownum
	Set pause off
	Support for XQuery in the SQL Worksheet
	Updatable views should allow insert, update and delete as for tables.
	Update look of Explain Plan
SQL Plus Commands	Autotrace
	Clear
	Echo
	Errors
	Feedback
	Host
	Pause
	Term
	Timing
	User
	XQuery
Tuning	Autotrace support
	Updated explain plan support

1.4  General

Import Data	Import data from spreadsheet (CSV or XLS format) into a table using SQL Developer
Export Data	Export data for more than one table at a time (with or without DDL)
	Export data to spreadsheet, from a table to XLS
	Export to HTML
Export DDL	Export DDL to include drop object
	INSERT data statement for multiple tables
	Option to export 'All My Objects'. Expand other users and select check user
	Option to suppress schema name
Search Engines	Oracle doc
	Search Doc10.2
	Search Doc9.2
	Search Forums
	Search Google
	Search Metalink
Performance	Ongoing updates to improve performance
Preferences	Added preference to display value instead of NULL values
	Additional user preferences for controlling the SQL Developer environment
	Allow fetch size to be greater than 5000
	Auto-freeze/pin tab
	NLS Date Format & other NLS parameters
	Open SQL worksheet on connect
	Set default path for file execution
	SQL Array Fetch size
	Object Viewer Parameters: Additional parameters to control DDL on the SQL tab
	Share user defined reports
	User Defined Extensions
	Define locations of third party JDBC drivers
PL/SQL Parser updates	Increased PL/SQL and SQL editing support, including improved parsing capabilities   - FOR UPDATE and ORDER BY clauses can be in either order   - Support for NTile function   - Insert statement support: The syntax supports an optional column list between INSERT and VALUE   - select cast('11-oct-2006' as timestamp) from ...
Menu	Added External Tool (Defaults)
	Added other External Tools
	F3 assigned to Find Next
	Schema diff   - Compare Source Schema and Objects with Destination schema to produce DDL   - Transfer SQL to SQL Worksheet

1.5  Reporting

Reporting	Allow for Import and Export of user defined reports
	Database Session Browsing through master - detail reports
	Export all reports
	Import all reports
	Increased right click actions
	Kill Session
	SQL Reporting
	Trace Session
User Defined Reports	Charting (select group,series,data from table)
	Copy shipped reports and paste as user defined reports
	Create & Run chart report
	Create & Run master detail reports
	Create a report using a script
	Create a report with plsql-dbms_output e.g. begin dbms_output.put_line('<h1>hello</h1>'); end;
	Create a reports with formatted code (e.g. select text from user_source where rownum < 100)
	Click through user defined reports using Report Id
	Define prompt for bind variables
	Drill down links
	Creating a User Defined Report, allow user to browse and bring in a file to populate the SQL
	Share User defined reports
	Increase the size in the SQL area for user defined reports
	Open user defined reports created in 1.0

2.  Known Issues

• General
• Connections
• Browse
• Query Builder
• Table Data
• PL/SQL
• Import/Export
• Linux Only
• Oracle 8.1.7 (Not Certified)
• Third Party Databases

2.1  General

• Extensions for SQL Developer 1.0, will not work automatically for Release 1.1.
• You can't invoke SQL*Plus TNSNames connections.
• Table alias auto complete does not support mixed case tables.

2.2  Connections

• Cannot connect to remote database as externally authenticated accounts
• Using connect identifier or thick connection can give Ojdbc errors on connection if the ORACLE_HOME is not v10.2.0.3

2.3  Browse

• Dependencies do not include synonyms.

2.4  Query Builder

• The Where Clause context menus only display on Mouse Over, otherwise there is only the shadow border.

2.5  Table > Data

• Navigating (tabbing) around Data Grid with keys does not work for up and down arrows. Use CTRL + up and down keys.

2.6  PL/SQL

• File -> Reopen File-> Fails. Use Navigate -> Go to Recent Files...

2.7  Import / Export

• When importing dates, you need to have explicit format masks.

2.8  Linux Only

• Browsing - Views > Data Tab - Actions is not working.
• Connections - Core dump while expanding a connection created using connection identifier.

2.9  Oracle 8.1.7

• SQL Developer is only certified for Oracle database 9.2.0.1 and above but we do have limited 8.1.7 functionality.

2.10  Third Party Databases

• Drag and drop table to the SQL Worksheet does not create the correct SQL syntax for MySQL.

3.  Accessibility Issues

The following is a list of known issues regarding accessibility using JAWS. The testing was done using JAWS version 5.10.

• Connections > New Connection - dialog box not read
• Connections - tree structure not read
• Tables > Create Table - buttons not read
• Data > Edit - buttons not read in edit value dialogue box
• Other User > Create User - not all items read
• Other User > Drop User - SQL statement under sql tab not read
• Any Object > right click - context menu not read
• Any Object - many tabs and details not read
• SQL Worksheet > right click table name > describe - contents of dialog box not read
• SQL Worksheet - query results not read
• SQL Worksheet > Query Builder - dialog box not read
• SQL Worksheet > right click - context menu not read
• View > Snippets - snippet details not read
• Tools > Export DDL > Options - checked options not read
• Help > Check for Update - dialog box not read
• Help - dialog and text not read
• General - menus not read
• General - toolbars not read
• General - main window title not read

4.  Globalization

4.1  Character Set Support

SQL Developer can connect to an Oracle Database irrespective of the database character set and the database national (NCHAR) character set. All functionality which does not involve entering or displaying characters outside of the ASCII character set is expected to work correctly with any such database.

Due to bug #5088284 in the JDBC 10.2 driver, the database character set ZHT16HKSCS31 is currently not supported.

Support for displaying and entering characters in scripts outside of the ASCII repertoire is limited to those fulfilling the following conditions:

• The character belongs to the database or to the national character set, depending on the datatype of the value containing the character, and
• The script to which the character belongs is supported by the JRE installation on which SQL Developer is running, for example, appropriate fonts are available, and
• The script does not require complex rendering, e.g. it is written left-to-right with no ligatures or character reordering.

Complex scripts, like Arabic, Hebrew, or Devanagari may work in many places, but they have not been tested and they are not guaranteed to work reliably. For bidirectional scripts, e.g. Arabic and Hebrew, no functionality is provided to right-align displayed columns, nor to set directionality. Full support for those languages is planned for a future release.

SQL Developer version 1.1 is available with English user interface only. If the locale of the operating system is not English, a few UI elements, like default wizard buttons and Oracle error messages, may show up in the language of this locale. If the locale of the operating system is Japanese, part of the user interface will appear in Japanese. These translations come from the framework on which SQL Developer is built. Full translation into selected languages is planned for a future release.

This version of SQL Developer has the following globalization issues:

5.  Other

5.1  If DDL tab is null for all objects in a Connection

Your dbms_metadata might be loaded incorrectly.
If this statement fails when executed in a SQL Worksheet against the Connection

   select dbms_metadata.get_ddl('TABLE',table_name , user ) from user_tables;

   IncludeConfFile  sqldeveloper-nondebug.conf