Oracle SQL Developer Release 1.5.1 - Release Notes

Date: 09 June 2008

Contents

  1. Before you Start!
  2. Once you have started
  3. Known Issues
  4. Hints and Tips
  5. New Features in SQL Developer 1.5

1.  Before you Start

  1. Oracle SQL Developer 1.5.1 is available for Windows (XP and Vista (including 64bit)), Linux or the Mac OS X.
  2. Installing or Upgrading:
    1. For SQL Developer releases prior to SQL Developer 1.5, this is a full installation. Download and unzip the file, into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
    2. For SQL Developer 1.5, use Check for Updates to update your existing SQL Developer 1.5 installation. You should select all the SQL Developer files in the Check For Updates dialog.
  3. Migrating preferences and connections from previous releases. After you have installed the product you are asked if you want to migrate from a previous release. This migrates previously set preferences and connections created.:
    1. To migrate your existing Release 1.2.1 connections, select Browse... on the dialog, navigate to and select the <sqldev 1.2.1 home>\sqldeveloper\sqldeveloper\system folder. In the future these system folder files are stored in the \Documents and Settings\<your_user>\Application Data\SQL Developer
    2. To migrate settings from SQL Developer 1.5, select Browse... on the dialog, navigate to and select the \Documents and Settings\<your_user>\Application Data\SQL Developer folder.
    3. If you are using Oracle SQL Developer 1.1.3 as part of the Oracle Database 11gR1 installation, navigate to [ORACLE_HOME] \product\11.1.0\db_1\sqldeveloper\sqldeveloper\system
  4. The SQL Developer 1.5.1 release is shipped with JDK1.5.0_06. You can use the embedded JDK or connect to a JDK you have installed. The minimum JDK you should use is 1.5.0_06. If you use JDK1.6 (JDK6.0), the minimum you should use is JDK1.6 Update 3. SQL Developer does not work with JDK 1.6 Update 1 and 2.
  5. In Oracle SQL Developer 1.5.1 your user-defined reports, SQL History and user-defined snippets files are located in the \Documents and Settings\<your_user>\Application Data\SQL Developer folder. These are also migrated.
  6. The JDBC drivers shipped are 11g R1. This means that users will no longer be able to connect to an Oracle 8.1.7 database.
  7. This release supports the Sybase 12 and Sybase 15 in addition to the current third party databases supported.
    • You will not see any third party tabs in the connections dialog until you have installed the drivers.
    • You can download and include the third-party database drivers manually. See the existing documentation for that on OTN. Alternatively y ou can use Check for Updates to setup these drivers.
    • Do not use the latest MySQL driver 5.1. Use the 5.0.x drivers for MySQL.
  8. Before you can use SQL Developer to connect to TimesTen:
    • Install the TimesTen 7.0.3 or later version of the server or client on the same machine as SQL Developer.
    • Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (install_dir/lib/ttjdbc5.jar).
    • On Linux, execute the shell script install_dir/bin/ttenv.sh or install_dir/bin/ttenv.csh to set up the correct TimesTen environment before launching SQL Developer.
    • Read these more detailed release notes on TimesTen

2. Once you have Started

3. Known Issues

General

  • Print data tab of table: entire data not printed
  • Functions not displaying return type
  • Performance in query builder when dragging first table onto page is poor
  • Update date in data grid, resets time details for date format without timestamp
  • MAC: "view files" should filter mac hidden files on the mac
  • Bind variable declared with variable command have case sensitive names
  • NLS preferences override the login trigger and session parameters
  • Timing and status message are wiped out on saving sql file
  • Format changes -- to /* -- instead of /* -- */
  • MAC: data tab's filter does not work well on mac
  • Closing unshared worksheet prompts for save twice
  • Unshared worksheet launch prompts inconsistently for password
  • Searching the Help shows "null" at the start of local doc results
  • Cannot see materialized views or synonyms in left-side Connections navigator

Formatter

  • Many keywords not recognized in formatter
  • Formatter does not right align set, and/or and breaks in strange places.
  • Auto format to upper, lower mixed case on keywords
  • Option to preserve blank lines between commands
  • Inappropriate spacing on certain options: = > instead of =>

Connections

  • Advanced Security Options for thin JDBC drivers are not supported

Create or Modify Objects

  • Loading jar file issues
  • Copy schema throws error for table with complex types defined in secondary schema

PL/SQL

  • Refresh or reconnecting to a user after privilege change does not update user

Export/Import

  • Cursor data exported to html does not render properly

Migrate

  • Migrate from sql server - data move fails with characters included & and '
  • Browsing sql server 2000 indexes panel does not work

TimesTen

  • Commit and rollback behavior for TimesTen DDL and DML operations: Unlike the Oracle database, TimesTen does not implicitly commit DDL transactions. The user must explicitly commit the transactions by clicking the Commit button on the SQL Worksheet.
  • Turning on passthrough can affect the SQL operations in the connections navigator. Make sure this setting is reset to 0 when switching from passthrough operations in SQL Worksheet back to the connections navigator.
  • DDL operations fail with when the Data tab is being viewed. Ensure that the data tab is not viewing the same table as the table you need to perform DDL on.
  • You cannot create tables when the SYS.TABLES system table is being viewed in SQL Developer. Viewing the content of SYS.TABLES in the Data tab causes a lock to be placed. All CREATE TABLE operations will time out because of this. The lock is released as soon as the focus of the Data tab is switched to another table. This is fixed in 7.0.5 and later version of the TimesTen In-Memory Database.
  • EXPORT DATA > INSERT generates Oracle-compatible SQL INSERT statements, depending on the underlying data type and the difference in support of literals. They may not be compatible with the TimesTen database.
  • EXPORT DATA > TTBULKCP generates an error when the action is performed inside the Data tab. Select this option from the connections navigator.
  • The LIKE filter does not find exact object match. The workaround is to use = instead of LIKE when defining the filter.

4. Hints and Tips

This is not a list of new features, but a few pointers that might be useful.

  • The SQL History is a dockable window in SQL Developer 1.5. You’ll find it at the lower portion of your screen. You can undock and drag the window to a location of your choice. For example, you can move and relocate it with the minimize snippets window.
  • The keyboard shortcut for the SQL History is ctrl (up or down)
  • To create a shared worksheet, use the SQL Worksheet button in the toolbar or the context menu (keystroke ctrl+shift+W). Assuming a connection is called “HR”, these shared worksheets are numbered as following HR~1, HR~2 etc.
  • To create a new, unshared worksheet, use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _1
  • You can drag and drop Insert or Select or Update or Delete statements onto the worksheet. There is a preference to make this choice set by:
    Tools -> Preferences: Database -> Worksheet Parameters
    The default is the current 1.2.1 behavior.
  • Please note the new SQL Formatter options available
    Tools -> Preferences: Database -> SQL Formatter
  • You can use force the use of the OCI/Thick driver using a preference
    Tools -> Preferences: Database ->Advanced Preferences
  • You can create code templates in the Preferences dialog.
    Tools -> Preferences: Database -> SQL Editor Code Templates
  • To use code editor templates you have created (in the preferences) use the keyboard shortcut ctrl-shift-T
  • You can choose to close all worksheets and all reports on disconnect. These are preferences.
  • Open a xxx.trc (tkprof) file in Oracle SQL Developer to see the formatted view of the file.
  • You can add connections to folders. Right click and add connection to existing folder or new folder. Folders are not migrated.
  • You can run DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.
  • Code Templates are now shareable : <user>/Application Data/Sql Developer/CodeTemplate.xml
  • SQL History can be recalled in the SQL worksheet through the keyboard. Please see Tools -> Preferences -> Others for reassignable keystrokes for recalling history.

5. New Features in Oracle SQL Developer 1.5

For a more comprehensive list of features please review the SQL Developer 1.5 Feature List

Feature Area Feature
SQL Worksheet Updated code insight. Allows users to use code completion for a greater number of object types
  Replaced SQL Formatting. See SQL Formatter preferences to control white space, tabs, comma placement, case, new line etc.
  Code Templates for frequently used code. Create these in Preferences, then through key stroke, in Code Editors and SQL Worksheet, import code template . ctrl+shift+T)
  Code Templates are shareable : <user>/Application Data/Sql Developer/CodeTemplate.xml
  Flashback. For 10g and 11g, you can use flashback on your data. See the Flashback tab on Tables.
  Keystroke to change case. (This is also available on a context menu.) Keystroke case is ctrl-quote
  Refactor code, see context menu on SQL Worksheet or Code Editors
  Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _1
  SQL History stores commands form F5 and F9 keystrokes. i.e Execute script or Execute statement. Note if you run @filename, this is what is stored in the History, not every command from the file .Keystroke ctrl-up and ctrl-down adds and scrolls through previously executed commands in the SQL Worksheet.
  Drag and Drop from Navigator to Worksheet for Insert, Update, Delete, Join and Select statements. Set preference.
 

Data Grid on tables retains Sort.

  Data Grid filter retains drop list of previous filter options
Navigator

View Queues and Queue tables

  Load and view Java
  Extended Search dialog in addition to DB Object search. This allows for searching for objects in code, such as parameters, declaration and usage.
  Create table from xls spreadsheet import.
  Run Manage Database report (right-click for context menu on any connection with privileges, such as SYS or SYSTEM)
  Run Manage Database report ( as SYS) to shut down and rest rat database
  Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.
Schema Copy

To copy contents of one schema to another

  Choices include drop objects, truncate and copy
  Preview report of actions to be executed
  Log report of results
Schema Diff

Compare and create SQL difference statements between 2 schemas

  Select objects to compare
  Report of objects to be compared
  List of differences and SQL Code to be executed
  Run script output to SQL Worksheet to be executed against connection of choice.
Export Wizard Export of DDL and Data updated to a wizard
  Includes object grants
  Select data for export
  Include drop commands
  Choice of dependent or independent objects
  View report of export to be run
  Export script opened in SQL Worksheet to run against user of choice
Import Import from XLS and create new table
  Import from CSV
Tip of the Day If you have any tips, submit them on the SQL Exchange or Forum for inclusion in the product.
Connections Force the OCI/thick driver connection, using a preference
  Support for LDAP and Authenticated Enterprise users
  Proxy user connections
  OS Authentication
  Add connections to folders
Tuning Open *.trc file in SQL Developer for a formatted trace file.
Preferences Support for a startup file such as login.sql. Add file choice to preferences.
Reports Monitor Sessions report is also on the main Tools menu
  Manage Database report on the context menu of the connection in the navigator
  Revised Migration reports
  Add reports with gauges
 

ASH and AWR reports(Available for connections to Oracle 11g R1 and above, and for users licensed for the Oracle Diagnostic pack)

PL/SQL Hierarchical Profiler (Available for connections to Oracle 11g R1 and above)
Third Party Databases Includes Sybase Adaptive Server 12 and 15 migration support
  Times Ten extension integrated into SQL Developer
Version Control Support for CVS and Subversion
Files An additional node for browsing the file system is available. File extensions associated with SQL Developer can be opened from the File Browser
Migration Quick Migrate is now a wizard.
TimesTen

Both direct-linked and client/server connections to TimesTen In-Memory database and In-Memory Database Cache

  Connections to databases with Access Control enabled as well as databases without Access Control enabled
  Connection Navigator support for selected database objects
  View, sort, search and edit data in existing tables, including cache and replication tables in the data grid
  Export of data from Oracle and TimesTen tables in TTBULCKCP text file format.