Oracle SQL Developer Changelog

What's new in Oracle SQL Developer 4.0.0.13.30 Early Adopter 3

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. Useability 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 3.2.20.09.87 (Nov 15, 2013)

  • 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. See this video on how to download and include third-party database drivers. Alternatively you can use Check for Updates to setup these drivers. Once the drivers are installed, view this video on how to create a connection to a third party database
  • 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
  • Bugs fixed:
  • TEMP TABLE VARCHAR NOT CONVERTED TO CLOB IF >4000
  • LINKS BETWEEN TWO TABLES NOT SHOW IN QUERY BUILDER TAB
  • DB2 DATA MOVE: UNLOAD DATA SCRIPT GENERAT ERRORS
  • COPY FROM MULTIPLE CELLS TO WORKSHEET WILL ONLY COPY FIRST CELL VALUE
  • 'COMPARE WITH' MENU IS MISSING AFTER RIGHT-CLICK A PLSQL OBJECT
  • PRODUCT FREEZES WHEN EXECUTING DEPLOY APEX
  • SQL IS DIFFERENT FROM QUICK DDL ON A TABLE FOR INDEXES
  • EXPLAIN PLAN EXPORT TO HTML NOT COPYING ALL REQD PNG FILES TO IMAGES DIRECTORY
  • PDF:HEADER AND FOOTER IS CUT WITH LARGE NUMBER OF ROWS
  • DATABASE SESSION KEEPS INCREASING WHEN 'MANAGE DATABASE' OPTION IS SELECTED
  • UNABLE TO CANCEL LONG RUNNING QUERY IN TASK VIEWER WHILE RUNNING CHART REPORT
  • QUERYING NUMBERS BEYOND JAVA'S MAXINT WILL PRODUCE NO OUTPUT
  • CANNOT USE MOUSE SCROLL OR PAGEUP/PAGEDOWNN TO NAVIGATE IN ASH/AWR-REPORTS
  • QUICK DDL FOR PROCEDURES INCLUDES ALL REFERENTIAL CONSTRAINTS
  • MEMBERS OF PACKAGE BODY NOT LISTED
  • OPEN DECLARATION DOES NOT WORK OVER DATABASE LINK
  • UI FREEZE WHEN EXEC A SQL AND IMPORTING AN APEX APPLICATION

New in Oracle SQL Developer 3.2.10.09.57 (Oct 9, 2012)

  • New Features:
  • APEX Listener:
  • SQL Developer is is now the interface to administer the Oracle Application Express Listener. The new interface enables you to specify global settings and multiple database settings with different database connections for the Application Express Listener. The APEX Listener supports configurations for Oracle Application Express and other deployments using Oracle WebLogic Server, Oracle Glassfish Server, and a standalone mode.
  • UI Enhancements:
  • SQL Developer provides continued enhancements to the user interface. Some enhancements include the option to drag and drop objects by table or column name onto the worksheet, improved DB Diff comparison options, GRANT statements support in the SQL editor and DB Doc reporting improvements.
  • 12c Database Support:
  • This release supports 12c Database features. Customers part of the 12c Database Beta program can test the latest 12c features.
  • Bugs Fixed:
  • Completion Insight Doesn't Show Schema
  • Error When Using Desc Statement From Worksheet
  • Fail To Generate Doc For Tables With Special Characters In Name
  • Generate Db Doc: Columns And Details Of Materialized View Log Incorrect
  • Ctrl + Click Procedure Name Is Case Sensitive
  • Xml Type Is Not Supported By Database Copy
  • Scrolling Query Result Rows Do Not Appear Using Jdk 1.7
  • Chart Reports Have No Task Viewer
  • Incorrect Generated Package Body If Package Name Has Double Quotes
  • Export File In Loader Format With Left/right Enclosure ' Causes Error
  • Database Export Fails For Excel When Writing Multiple Tables To A Single File
  • Query Parser Doesnt Respect Quoting Of String Literals (q' And Binds)
  • Parser: Q-quote Fails In File Editor If String Contains No Single Quotes
  • Interval Day To Second Is Displaying Unwanted Fractional Seconds
  • Publish To Apex Not Working For Apex 4.1
  • Floating Decimal Field Displays Differently In Sqlplus
  • Function That Returns A Clob, Nothing Displayed In Output
  • Trigger Code In Other Schema Not Visible In Browser
  • Leading Spaces Lost In Worksheet When Executing Query
  • Cursor Output After Debugging Missing
  • Column Exclusion In Export Wizard Not Working From Data Tab
  • Package Compiled At Wrong Connection
  • Databasecopy Time Portion Of A Date Field Is Truncated To 12:00:00
  • Support For Multi Case Scheduler Object Names
  • Unable To Copy Bfile Datatype Row If The Value Is Null
  • Query Result / Script Output Display Wrong Line/column Numbers
  • Generate Db Doc Of A Function Returns Wrong Syntax
  • Editioning View Will Disappear After Edit
  • Unable To Generate Grant Statements
  • Data Loader Format Options Not Working
  • Grants Not Showing On Sql Tab Of Object Editor
  • Deadlock Occurs When Opening Worksheet Connection For A Sql File
  • Deadlock Occurs When Switching Worksheet Connections
  • Keyword Parsing Problem Truncates Pakage Member Tree Structure

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 (Dec 12, 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.