Oracle SQL Developer 3.0 Early Adopter 1: New Feature List


Date: October 2010

This document is a list of new features available in Oracle SQL Developer 3.0 EA1.  For a comprehensive list of SQL Developer features see Feature List.

New Feature Areas

  1. DBMS Scheduler
  2. DBA Functionality
  3. Files and Version Control
  4. Migrations
  5. PDF
  6. PL/SQL Support
  7. Query Builder
  8. Schema Browser
  9. SQL Plus Commands
  10. Spatial
  11. Tuning
  12. Unit Testing
  13. Unloading and Uploading
Area Feature Description
1. DBMS Scheduler   Create a full schedule definition using graphical and grid editors
  Programs Basic tasks which could be external procedures, pl/sql or stored procedures
  Schedules Specify when and how many times a job is executed
  Jobs Objects that are scheduled which could be Programs or Chains
  Job Classes Group jobs for resource allocation and prioritization
  Chains Create a flow of Chain Steps that are linked together by Chain Rules to create more complex Jobs
  Credentials Assign a username/password pair that is used by jobs to authenticate with a host operating system or Oracle Database
  Database destinations Specify Oracle database on which remote database job run on
2. DBA Functionality DB Configuration Ability to review and tune db config and edit initation parameters
  Resource Manager Create and prioritize consumer groups and manage resource plans
  Security Define audit settings and manage profiles, roles and users
  Storage Define and manage archive logs, control files, datafiles, redo logs, rollback segments and tablespaces
3. Files and Version Control File Based Debugging Set breakpoints in PL/SQL files (.pls, .pkb, etc) and run or debug these files
4. Migrations Full command line support All major migration functions can now be run on the command line
  Server Capture support Ability to capture all the databases in a server for SQL Server and Sybase
  Project support for Migrations New project navigator
  Application Scanning and Migration for Sybase DBLIB and CTLIB applications Scan all the application code in an application and make changes to it so it will compile and run against an Oracle database
  Migration Project Estimation Ability to work out a time and resource duration for a database migration project
  Migration Reports Reports for detailed analysis of source objects, converted objects and issues with migrations
  Improved identifier and name mapping Define the names of target objects before the migration starts
5. PDF Customizable Layouts Customize table, column and cell layout which includes fonts, styles, row shading, borders, alignment, padding, spacing and wrapping text. Options to include column headers and column footers.
  Binary Large Object Support Images, video, text, doc, spreadsheets, and other objects embedded in the PDF document, or linked as separate files
  Document Compression Different levels of document compression
  Meta data Meta data such as title, name, subject and keywords
  Security Password-protect a pdf document, permission password for security settings and different levels of encryption
  Version Support Version support from 1.5 to latest release
6. PL/SQL Support Parser Code completion was amended with additional templates automatically derived from PL/SQL and SQL syntax
  Debugging PL/SQL debugging of anonymous blocks
  Ref Cursor Run and debug procedures with ref cursors
    Display ref cursor data
7. Query Builder Query Builder Viewer 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
  Automatic Join Creation Automatically determine and show joins between related tables added to the Query Builder canvas. Can also drag/drop columns to manually create them
  Multiple Join Types Join properties in clear user terms (“Show all <Employees>”) remove confusion with LEFT OUTER, RIGHT FULL, etc. syntax
  Grouping, Predicates, Sorting Column visibility, alias name, grouping, sorting and selection predicates are shown in an easy to use table layout
  Derived Tables, Sub-Queries, and Unions Derived Tables, Sub-Queries, and Unions are shown as sub-tabs in the Query Builder and can be edited in the same way as the main query
8. Schema Browser   Easier navigation between object types and schemas for a specific connection
    Support fast client-side name based filtering for narrowing the list of objects displayed
9. SQL Plus Commands   View all supported SQL Plus Commands
10. Spatial Spatial Data Management Identify tables/views and materialized views that contain spatial datatype columns
    Define /Validate spatial metadata and indexes
    Show and manipulate spatial data instances on a new 'map' view
    Interact with objects on the map view
    Validate spatial data instances
11. Tuning SQL Tuning Advisor Analyzes submitted high-volume SQL statement and offers tuning recommendations
  Diff Tool for Explain Plans Compare selected Explain Plan or Autotrace results for any SQL statements.
  Management Pack Licensing Preferences Preferences option to track which Oracle database features are claimed to be licensed on a connection-by-connection basis
12. Unit Testing   Advanced Data Types Support
    Multi-user support
    Multiple startups/teardowns
    Nested suites
    Purge run results
    Rename test implementation
    Test synchronization and retargeting tests
    Export tests
13. Unloading and Loading (previously known as Exporting and Importing) Load Data Customizable user interface based on Preference settings
    Dynamic data preview reflects changes as they are made to the file definition
    Delimited file support allowing specification for delimiters, enclosures, line terminators, and file encoding
    New “Staging External Table” load method provides generation of an external table used as a staging table for the load. Data is inserted into the table by selecting from the staging external table
  Unload Data Customizable user interface based on Preference settings
    Delimited file support allowing specification for delimiters, enclosures, line terminators, and file encoding
    PDF file support based on Preference settings
    Extended object search capability to include schema and object type
    Ability to unload data from views and materialized views
    Options to write output to a single file, separate files for each object, separate files for each object type, and files into separate directories by object type