Softpedia >Mac >Developer Tools >Oracle SQL Developer >  Changelog

Oracle SQL Developer Changelog

What's new in Oracle SQL Developer 4.0.0.13.30 EA3

Nov 15, 2013
  • Database Performance Monitoring:
  • SQL Developer now provides a full interface for Oracle Database Enterprise Edition’s Diagnostic pack, including Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH). Accessible from the DBA panel, users can also manage their snapshots, baselines, and baseline templates.
  • Find Database Object - Search:
  • The database search is completely redesigned. The new tree layout allows for searches on multiple schema, object type, identifier types and usages. A history of your searches will be stored for later access. Search results can be viewed in a separate Editor where multiple search results can be pinned and displayed.
  • Command Line:
  • Command Line support has been extended to Reporting and to the Cart. You can run Reports and generate them into HTML format through the command line. The Cart commands offer the ability to export objects and data. A set of predefined DDL generation options and data formats can be applied.
  • Cart:
  • The Cart has been greatly enhanced. You can create and work on multiple carts. The deployment of objects has been extended to give you more flexibility in selecting export DDL options and data formats. Export Object configurations can be saved and applied again. Compare Cart objects to another Cart or Connection with the Database Diff. Cart objects can also be copied with the Database Copy feature. Scripts are extended to include Before and After Data Load.
  • Reports:
  • Creating reports has never been easier. The create new report dialog has a tree layout for ease of navigation. An Advanced Option is available to instantly create Child and Drill Down type reports. Chart based reports include more chart types and you can test reports from anywhere within the report editor. Charts can be previewed in design mode. An HTML Report can be generated for any report. Enhancements in Database Doc generation include better layout and support for multiple threads to improve performance.
  • UI Enhancements:
  • The new UI changes in 4.0 enhances the overall look and feel of SQL Developer. A popular request on the Feature Exchange, a window border color can be dynamically set for a database connection. Usability improvements can be seen with with the new floating Editor and Navigation windows.
  • Data Modeler 4.0:
  • This version includes the new Data Modeler release 4.0. New features include 12c support for IDENTITY columns and masking of sensitive data with Redaction policy definitions at table and column level, create Transparent Sensitive Data Protection (TSDP) policies and associate it with sensitive types.
  • JDK 7 Support:
  • This release supports JDK 7 and above.

New in Oracle SQL Developer 4.0.0.12.27 EA1 (Sep 4, 2013)

  • Find Database Object - Search:
  • The database search is completely redesigned. The new tree layout allows for searches on multiple schema, object type, identifier types and usages. A history of your searches will be stored for later access. Search results can be viewed in a separate Editor where multiple search results can be pinned and displayed.
  • Command Line:
  • Command Line support has been extended to Reporting and to the Cart. You can run Reports and generate them into HTML format through the command line. The Cart commands offer the ability to export objects and data. A set of predefined DDL generation options and data formats can be applied.
  • Cart:
  • The Cart has been greatly enhanced. You can create and work on multiple carts. The deployment of objects has been extended to give you more flexibility in selecting export DDL options and data formats. Export Object configurations can be saved and applied again. Compare Cart objects to another Cart or Connection with the Database Diff. Cart objects can also be copied with the Database Copy feature. Scripts are extended to include Before and After Data Load.
  • Reports:
  • Creating reports has never been easier. The create new report dialog has a tree layout for ease of navigation. An Advanced Option is available to instantly create Child and Drill Down type reports. Chart based reports include more chart types and you can test reports from anywhere within the report editor. Charts can be previewed in design mode. An HTML Report can be generated for any report. Enhancements in Database Doc generation include better layout and support for multiple threads to improve performance.
  • UI Enhancements:
  • The new UI changes in 4.0 enhances the overall look and feel of SQL Developer. A popular request on the Feature Exchange, a window border color can be dynamically set for a database connection. Useability improvements can be seen with with the new floating Editor and Navigation windows.
  • Data Modeler:
  • This version includes the new Data Modeler release 4.0. New features include 12c support for IDENTITY columns and masking of sensitive data with Redaction policy definitions at table and column level, create Transparent Sensitive Data Protection (TSDP) policies and associate it with sensitive types. See the full list of New Features here.
  • JDK 7 Support:
  • This release supports JDK 7 and above.

New in Oracle SQL Developer 3.2.20.09.87 (Dec 14, 2012)

  • Before You Start:
  • Platform Support
  • Oracle SQL Developer 3.2 is available for Windows XP , Vista (including 64-bit), Windows 7 (including 64-bit), and Windows Server 2008, Linux or Mac OS X. (See Certification)
  • JDK Support:
  • Oracle SQL Developer 3.2 release is shipped with JDK 1.6.0_35. You can use the embedded JDK download or connect to an installed JDK. SQL Developer supports a minimum java version of 1.6.0_04 to a maximum java version less than 1.7.
  • 64-Bit Windows Support:
  • There is a separate download for the 64-bit environment. Download the full 64-bit install and unzip into a new, empty directory as described for other platforms. Execute the sqldeveloper.exe. You need to download and install the 64-bit JDK for your platform.
  • Installing or Upgrading:
  • The Check for Updates option to upgrade between releases of SQL Developer is not supported. This utility is provided to install third party extensions, this includes the third party drivers required for migrations and to add additional version control extensions.
  • All new releases of SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
  • Migrating 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:
  • By default the Confirm Import Preferences dialog that is displayed selects the latest installation. Select Yes to migrate the settings from that release or click the Show All Installations button to browse to an earlier installation. You can migrate settings from SQL Developer 1.2.1 and above.
  • If you are migrating from a release earlier than SQL Developer 1.5.x:
  • Select the magnifying glass to browse to the sqldeveloper\sqldeveloper\system folder
  • Click Select. This closes the browse dialog.
  • Note: the selection is not added to the list displayed in the Confirm Import Preferences dialog.
  • Click Yes, to migrate the Connections and settings from the selected release.
  • Note: If you are using Oracle SQL Developer 1.1.3 as part of the Oracle Database 11gR1 installation, search for the [ORACLE_HOME] \product\11.1.0\db_1\sqldeveloper\sqldeveloper\system folder
  • NOTE: If you install a release later than 1.1.3, this does not replace the menu item in your Start Programs list. You can add your own menu option here or a shortcut on the desktop.
  • User Defined Reports, Snippets and SQL History:
  • User-defined reports, SQL History and user-defined snippets files are located in the \Documents and Settings\\Application Data\SQL Developer folder. These are also migrated.
  • Folders:
  • If you created folders in release 1.5.1 or above, these are automatically included in the migration. If you choose not to migrate your settings between releases, then you can import your old connections. This does not include folders.
  • JDBC Drivers:
  • The JDBC drivers shipped are Oracle Database 11g Release 1. To connect to earlier version of the database using the Thick Driver, you need to install an 11g client. The 11g client is not required for the Basic Connection.
  • Debug Log Window:
  • This is now set off by default. If you want to see the SQL Developer debug log window information by default, then include the line "IncludeConfFile sqldeveloper-debug.conf " in the sqldeveloper.conf file.
  • To start up the debug log window in the product while you are working, enter "setloglevel oracle.dbtools ALL" in the SQL Worksheet. This will stay on while you are working, but won't reopen the log window if you stop and restart the product.
  • Third Party Databases:
  • SQL Developer supports IBM DB2 UDB LUW , Microsoft SQL Server and Microsoft Access, MySQL, Sybase Adaptive Server and Teradata. See Supported Platforms for details on all third party database releases supported.
  • You will not see any third party tabs in the connections dialog until you have installed the drivers. Read this Getting Started document to show you how.
  • You can also download and include the third-party database drivers manually. See the existing documentation for that on OTN. Alternatively you 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.
  • TimesTen and In-Memory Database Cache:
  • Before you can use SQL Developer to connect to TimesTen:
  • Install TimesTen 11.2.2 (11.2.2.0.0 or greater) or TimesTen 11.2.1 (11.2.1.4.0 or greater) of the server or client on the same machine as SQL Developer.
  • On Linux systems, source the shell script TimesTen_install_dir/bin/ttenv.csh or TimesTen_install_dir/bin/ttenv.sh to set up the TimesTen environment variables before launching SQL Developer. On Windows, use the TimesTen_install_dir\bin\ttenv.bat script.
  • Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (TimesTen_install_dir/lib/ttjdbc6.jar).
  • Read these more detailed release notes on TimesTen.
  • Table Filters:
  • The list of tables displayed includes generated tables, AQ's and others not previously included in the list. By default there is a filter on the Tables node to exclude objects from the recycle bin.
  • Code Templates/Snippets:
  • Code insight contains a comprehensive database of code fragments fetched from SQL and PL/SQL reference manuals. Upon a user entering a keyword prefix in SQL Developer, code insight brings up the list of code fragments syntactically valid within the user source context. Each list entry is amended with a button referring to the documentation web page. In a similar venue, SQL Developer suggests query fragments fetched from SQL history.
  • Version Control:
  • Subversion is installed by default with SQL Developer 3.2. To install CVS, Perforce and Serena Dimensions, please use Help > Check for Updates.
  • Subversion:
  • If you create a local Subversion repository, ensure there are no spaces in the path.
  • CVS
  • If you use a local repository. You must use an external CVS client and set the CVS versioning properties to point to the external client.
  • Fonts:
  • The font setting for the Code Editor now also increases the font size for the script output window and all data grids. This is in addition to increasing the font size for the SQL Worksheet and PL/SQL Code Editors. Select Tools | Preferences | Code Editor | Fonts and set the font size.
  • Data Miner:
  • Oracle Data Miner requires Oracle Database 11g Release 2 (11.2.0.1) or higher. More information can be found in the Data Miner Release Notes.
  • Support:
  • You are supported by Oracle Support under your current database Support license for SQL Developer production releases. Log SQL Developer bugs and issues using My Oracle Support for the product.
  • Feedback:
  • There are a number of different forums supporting the features in SQL Developer. When using the forums, be sure to use clear subject lines to initiate a thread and try to avoid using old, unrelated threads for a new issue.
  • You can discuss features on the Oracle SQL Developer forum
  • For all Data Mining related queries, please use the Data Mining forum
  • For all TimesTen related queries, please use the TimesTen forum forum
  • For all Data Modeler related queries, please use the Data Modeler forum
  • For all Database Migration related queries, please use the Migrations forum
  • General Comments:
  • Features not yet supported in this release can be added to the Feature Requests section on the Oracle SQL Developer Exchange.
  • Please review current certification status for platform and database certification queries.
  • Support for TimesTen In-Memory Database is included in SQL Developer 3.2. You will not see the TimesTen Connection node unless you have TimesTen installed and configured (see TimesTen section above).
  • Support for TimesTen In-Memory Database includes support for Oracle In-Memory Database Cache and TimesTen In-Memory Database Release 11.2.1.4 and later.
  • If you did not migrate your connections from a previous release, you can import them afterwards. Invoke the earlier release of SQL Developer, export the required connections and import them in the new release.
  • Expired password: When a password expires, an error message is raised to alter the user. To reset the password, right-click the connection and select Reset Password.
  • Bugs Fixed:
  • 11059624 TEMP TABLE VARCHAR NOT CONVERTED TO CLOB IF >4000
  • 13101024 LINKS BETWEEN TWO TABLES NOT SHOW IN QUERY BUILDER TAB
  • 14553206 DB2 DATA MOVE: UNLOAD DATA SCRIPT GENERAT ERRORS
  • 14765883 COPY FROM MULTIPLE CELLS TO WORKSHEET WILL ONLY COPY FIRST CELL VALUE
  • 13772678 'COMPARE WITH' MENU IS MISSING AFTER RIGHT-CLICK A PLSQL OBJECT
  • 14671155 PRODUCT FREEZES WHEN EXECUTING DEPLOY APEX
  • 14474159 SQL IS DIFFERENT FROM QUICK DDL ON A TABLE FOR INDEXES
  • 14770237 EXPLAIN PLAN EXPORT TO HTML NOT COPYING ALL REQD PNG FILES TO IMAGES DIRECTORY
  • 13725401 PDF:HEADER AND FOOTER IS CUT WITH LARGE NUMBER OF ROWS
  • 14693373 DATABASE SESSION KEEPS INCREASING WHEN 'MANAGE DATABASE' OPTION IS SELECTED
  • 14466031 UNABLE TO CANCEL LONG RUNNING QUERY IN TASK VIEWER WHILE RUNNING CHART REPORT
  • 14733141 QUERYING NUMBERS BEYOND JAVA'S MAXINT WILL PRODUCE NO OUTPUT
  • 13434634 CANNOT USE MOUSE SCROLL OR PAGEUP/PAGEDOWNN TO NAVIGATE IN ASH/AWR-REPORTS
  • 14674069 QUICK DDL FOR PROCEDURES INCLUDES ALL REFERENTIAL CONSTRAINTS
  • 14680316 MEMBERS OF PACKAGE BODY NOT LISTED
  • 14661674 OPEN DECLARATION DOES NOT WORK OVER DATABASE LINK
  • 8892376 UI FREEZE WHEN EXEC A SQL AND IMPORTING AN APEX APPLICATION

New in Oracle SQL Developer 3.1.06.44 EA2 (Dec 12, 2011)

  • New Features:
  • DBA Utilities:
  • Release 3.1 continues to expand on SQL Developer's DBA functionality. RMAN, Oracle Recovery Manager, is now part of the DBA navigator. An easy to use wizard takes you through the scheduling of a full database backup. Backups can be stored to disk, tape or a combination. RMAN scripts are generated to restore or recover a whole database, tablespaces, datafiles and archived logs. Reports are available to manage backup jobs, backup sets, image copies and RMAN settings.
  • Data Pump:
  • To enable very high speed movement of data and metadata from one database to another, SQL Developer has added the Oracle Data Pump technology. Use SQL Developer's Data Pump UI to import and export your Database, Tablespaces, Schemas, and Tables. Select the option to import and export just the DDL, Data or both. Data Pump also offers scheduling capabilities.
  • Database Diff:
  • Completely redesigned, DB Diff now provides a more reliable comparison and difference management support of your DDL. Select what to include in your DDL Generation and select from various comparison options such as match constraints by name or by definition. Objects can be further filtered. Scripts are generated to synchronize the source and target destinations.
  • Database Copy:
  • Database Copy is redesigned to enhance performance and offer more flexibility. Choose from various copy options: copy objects, copy a schema or consolidate multiple schemas into one, copy tablespaces, copy DDL, data or both. Further refine your copy by using the filtering capability.
  • Migrations:
  • Migrations in 3.1 include enhancements to Teradata and Sybase. Teradata support has expanded to include a SQL Translator, Enterprise Capture and Offline Migration. Sybase now offers TSQL Translation with support for outer join syntax including legacy outer join syntax and triggers.
  • PDF Reports:
  • The Reports dialog is enhanced for ease of use and flexibility to create or update a report. The PDF feature allows the user to change and save their PDF options for a specific report in the Reports Navigator. Customize the visual layout and apply security with password protected encryption to your PDF Reports.
  • Bugs Fixed:
  • Accessibility:
  • Improving accessibility within the product is an ongoing process.
  • Browser:
  • Special privileges not required to view objects
  • Click view's detail tab get stream closed error
  • Procedures and functions are not listed
  • Newly created packaged function not visible in another sql developer session
  • Connect, create and modify:
  • Could not create crossedition triggers using gui
  • Dba:
  • Restore point ui/sql assume 11g feature set and fails against 10g
  • Restore point: need to disable as of scn/timestamp on 10g
  • Export and import:
  • Export fails with timestamp field and loader format
  • General:
  • Erroneous copy/paste behavior with multiple data grids open
  • Selected grid cell unreadable with zebra stripes on
  • 8981987 creating xml schema cannot give url longer than 30 chars
  • Sql developer can't recognize the jdk version while invoking sqldeveloper
  • Migration:
  • Unable to migrate sybase triggers in offline migration
  • Reports:
  • Open password and permission password should not be blank
  • Fail to export report in pdf format with large column heading/footing size
  • Report description text does not auto-scroll for long input
  • Sql:
  • Sql formatting problem in oracle sql developer
  • Translations:
  • Providing full translations of the product is part of the development process. There are ongoing updates to ensure the product is fully translated.
  • Worksheet:
  • Ora-00600:: [ho define: long fetch] using sqldeveloper
  • Script causes infinite loop - ok if pagesize and linesize removed
  • No print issue at start of apex install
  • Compilation error when underlying column "in" datatype is sys.Xmltype
  • Space appended to statement lines if there is a hyphen ("-")

New in Oracle SQL Developer 3.0.04.34 (Apr 19, 2011)

  • Data Miner: A new SQL Developer extension, Oracle Data Miner is the graphical user interface for Oracle Data Mining, an option to the Oracle Database Enterprise Edition. Oracle Data Mining provides in-database functionality that enables users to discover patterns and relationships hidden in their data to predict customer behavior, identify key factors, find new clusters and their profiles, anticipate and combat churn, detect anomalous behavior and solve a wide range of data-driven problems. For more information, visit Oracle Data Miner on OTN.
  • Data Modeler: SQL Developer Data Modeler 3.0 is now fully integrated, providing read and write access for designing and developing data models. The readme.html for SQL Developer Data Modeler 3.0 can be found in the SQL Developer installation in the folder \sqldeveloper\sqldeveloper\extensions\oracle.datamodeler.
  • Exporting and Importing: The Importing and Exporting wizards have been updated to support a wider range of choices. During the early adopter release cycle Export was renamed to Unload and Import to Load. Following user feedback, we have reverted to the original terms of Import and Export. You'll find these on the Tools > Database Export menu, and Export... on the context menus for Tables and Views and on Data Grids. Import Data is available on table context menus.
  • Database Navigator: Users can now manage Database Configuration files, Resource consumption, Security for profiles, roles and users, and manage Storage files such as control files, datafiles, archive and redo logs, rollback segments and tablespaces.
  • DBMS Scheduler: The Scheduler enables you to control when and where various computing tasks take place in the enterprise environment. The Scheduler helps you effectively manage and plan these tasks. Scheduler objects include: programs, schedules, jobs and job classes, destinations, chains and credentials are now added to the Connections Navigator. A graphical editor called the Scheduler Design Editor can be used to create and run scheduler objects.
  • SQL Tuning: SQL Tuning Advisor analyzes high-volume SQL statement and offers tuning recommendations. A Diff Tool for Explain Plans compares selected Explain Plan or Autotrace results for any SQL statements.
  • Query Builder: Visual SQL Query Builder with an object drag and drop feature from the connection navigator to the Query Builder view. SQL Worksheet and Query Builder view are tightly integrated. Switch between Worksheet (text) and Query Builder (visual) views at any time.
  • Spatial Data Management: Spatial Data Management provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database.
  • Schema Browser: The Schema Browser supports fast client-side name based filtering for narrowing the list of objects displayed.
  • Migrations: SQL Developer 3.0 brings a number of new features that support the migration from non-Oracle to the Oracle Database. A significant change is the concept of the Migration Project, a new navigator that holds all the servers in a project all together, which means that users can run several projects together, but report centrally on any one of them at any time with detailed information. The Enterprise Capture allows the user to point at a server and capture all the databases in that server. A number of different estimation reports provide detail on the high level object and error summaries, detailed errors and detailed comparison between source objects, capture and converted objects and the new Oracle objects. The Copy to Oracle feature allows users to copy tables and procedures from third parties into an Oracle schema, without a migration repository. See Getting Started for setting up and starting a database migration.

New in Oracle SQL Developer 2.1.1.64.39 (Mar 5, 2010)

  • Browser:
  • 8979917:Double-clicking objects in the navigator tree expands the node
  • 9043815: Delete package in recent objects but package body still remains
  • 9083514: Mixed case does not work for editions node
  • 9215395: Package and its body has the same name in 'bookmark' view
  • Data:
  • 8898544: Data committed in another/same session, when updating data
  • 8992313: Grid should persist the previously applied sort
  • 9104582: MAC: command copy no longer works in the data grid
  • 9201318: Typing in text field of xml type cell does not set the cell value
  • 9217549: Timestamp type can not edit the time part in 'edit value' dialog
  • 9249033: Update the column data with character '@' will show ora-04054
  • Database Diff:
  • General Database Diff bugs have been reported and noted. These are scheduled for the next release.
  • Export:
  • 9022960: Export data is missing quote for varchar datatype
  • 9146213: Sort the header in 'where' tab in export data, it is not showing the arrow
  • 9154559: Database copy: does not copy directories
  • 9179058: Export of large query blocks access to other tables in connection
  • 9190964: Export data fixed format, the fixed length is always 30 bytes
  • 9195913: Export data date type, will be exported like timestamp
  • 9199991: Import data: source/target data columns mismatch
  • 9201927: Import XLS loses line breaks
  • 9214731: Import data under other user, it was not imported into other schema
  • 9307157: Export data rowid type will fail to export
  • Formatting:
  • 9215563: SQL formatting: tables moved to new line incorrectly
  • 9255625: Different procedure formatting before and after insert
  • General:
  • 9186667: TNSping is hard coded to sid does not use service name
  • 9062844 :DBMS_OUTPUT is not available for new session ('cloned' connection)
  • 9197939: Code Insight does not work on describe.
  • Migrations:
  • A number of bugs raised in DB2 and Teradata migrations due to ongoing and deeper testing of the new functionality introduced in SQL Developer 2.1
  • Preferences:
  • 9177120: Migrate setting 1.5.4 to 2.1, global ignore list is not migrated
  • PL/SQL:
  • 9203385: PL/SQ: Edit: wrap selection entry not enabled in worksheet
  • Query Builder:
  • General Query Builder bugs have been deferred. The Query Builder is scheduled for rewrite in the next release.
  • Source Code Control:
  • 8890147: Dimension versioning: can not edit or check out multiple files
  • 9066753 SVN:'import files to subversion' can't continue if opened file is not saved
  • 9285693: SQL Developer removes the stored password in SVN application data
  • Unit Testing:
  • 9161664: Commit overlap in unit testing: New updates to multi-user access is scheduled for next release
  • Worksheet:
  • 9084878: File | Save As for temp worksheet does not set the connection on new worksheet
  • 9179920: Closing SQL Worksheet tab without commit/rollback leaves open cursors on db
  • 9202102: DESC type gives types from all schema
  • 9202042: Binds found since q'{ syntax does not get picked up.
  • 9205563: Statement output tab needs the dancing icon and progress bar

New in Oracle SQL Developer 2.1.0.63.73 (Jan 20, 2010)

  • Oracle SQL Developer Unit Testing provides a unit testing framework that allows you to build a set of sequential steps to create test cases for testing your PL/SQL code. These tests can optionally be collected into test suites, which can then be run and rerun to verify required functionality after any changes to your PL/SQL code. Command line access for executing, exporting, and importing suites or tests is provided for integration with your build and version control environment.
  • SQL Developer 2.1 incorporates a Data Modeler viewer, integrated into SQL Developer. The Data Modeler Viewer also supports visualizing tables, views and object types on read-only Data Modeler diagrams. The SQL Developer Data Modeler Viewer extension is a free extension to SQL Developer. For a updateable data model, download and review the Oracle SQL Developer Data Modeler, a stand alone product that supports logical, relational and conceptual modeling. The tool supports forward and reverse engineering and import and export from various sources. The Data Modeler supports an additional standalone model viewer, which allows users to open models built in the full Data Modeler.
  • The SQL Worksheet has been redesigned for SQL Developer 2.1 to support concurrent task processing for long running operations. Updates to the worksheet include the support of multiple data grids off the F9 (Run Statement) command and dockable OWA, DBMSOutput and SQL History windows.

New in Oracle SQL Developer 1.5.5.59.69 (Jul 15, 2009)

  • The release that will be incorporated into Oracle Database 11gR2.
  • This has minor updates to release 1.5.4 and no focus on new functionality.

New in Oracle SQL Developer 1.5.4.59.40 (Mar 17, 2009)

  • Oracle SQL Developer 1.5.4 release is shipped with JDK 1.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.
  • In Oracle SQL Developer 1.5.4 your user-defined reports, SQL History and user-defined snippets files are located in the Documents and Settings\Application DataSQL Developer folder. These are also migrated.
  • If you created folders in release 1.5.1 or 1.5.3, these are automatically included in the migration. If you choose not to migrate your settings between release, then you can import your old connections. This does not include folders.

New in Oracle SQL Developer 1.5.1.54.40 (Jun 10, 2008)

  • 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 : /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
  • Navigator: Load and view Java
  • Navigator: Extended Search dialog in addition to DB Object search. This allows for searching for objects in code, such as parameters, declaration and usage.
  • Navigator: Create table from xls spreadsheet import.
  • Navigator: Run Manage Database report (right-click for context menu on any connection with privileges, such as SYS or SYSTEM)
  • Navigator: Run Manage Database report ( as SYS) to shut down and rest rat database
  • Navigator: 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
  • Schema Copy: Choices include drop objects, truncate and copy
  • Schema Copy: Preview report of actions to be executed
  • Schema Copy: Log report of results
  • Schema Diff: Compare and create SQL difference statements between 2 schemas
  • Schema Diff: Select objects to compare
  • Schema Diff: Report of objects to be compared
  • Schema Diff: List of differences and SQL Code to be executed
  • Schema Diff: Run script output to SQL Worksheet to be executed against connection of choice.
  • Export Wizard: Export of DDL and Data updated to a wizard
  • Export Wizard: Includes object grants
  • Export Wizard: Select data for export
  • Export Wizard: Include drop commands
  • Export Wizard: Choice of dependent or independent objects
  • Export Wizard: View report of export to be run
  • Export Wizard: Export script opened in SQL Worksheet to run against user of choice
  • Import: Import from XLS and create new table
  • Import: 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
  • Connections: Support for LDAP and Authenticated Enterprise users
  • Connections: Proxy user connections
  • Connections: OS Authentication
  • Connections: 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
  • Reports: Manage Database report on the context menu of the connection in the navigator
  • Reports: Revised Migration reports
  • Reports: Add reports with gauges
  • Reports: 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
  • TimesTen: Connections to databases with Access Control enabled as well as databases without Access Control enabled
  • TimesTen: Connection Navigator support for selected database objects
  • TimesTen: View, sort, search and edit data in existing tables, including cache and replication tables in the data grid
  • TimesTen: Export of data from Oracle and TimesTen tables in TTBULCKCP text file format.