Oracle SQL Developer 3.0: New Feature List


Date: March 2011

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

New Feature Areas

 Data Mining  PL/SQL Support
 Data Modeler  Query Builder
 DBMS Scheduler  Schema Browser
 DBA Functionality  SQL Plus Commands
 Exporting and Importing  Spatial
 Files and Version Control  TimesTen
 Menus  Tuning
 Migrations  Unit Testing
Area Feature Description
Data Mining Oracle Data Miner 11g Release 2 GUI Oracle Data Mining, an Option to the Oracle Database EE, provides powerful data mining functionality as a feature of the database
    Oracle Data Miner, a free download from the Oracle Technology Network with SQL Developer 3.0, simplifies and automates the data mining process
    Oracle Data Miner help users mine their data and define, save and share advanced analytical methodologies
    Visualize data, perform data transformations for data mining
    Build, evaluate and apply classification, clustering, anomaly detection, text mining, market basket, etc. predictive models
    Developers can use the SQL and Java APIs to build applications to automate knowledge discovery
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.
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
DBA Functionality Database Configuration Ability to review and tune Database configuration and edit initialization 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
Exporting and Importing Import 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
  Export 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
Files and Version Control File Based Debugging Set breakpoints in PL/SQL files (.pls, .pkb, etc) and run or debug these files
Menus Connections Recompile Schema on a connection
    Disconnect All connections
  Tables Generate Table API on the Tables node
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. All migration tasks are now wizard based to manage the  process
  Application Scanning and Migration for Sybase DBLIB and CTLIB applications The applications scanning is only supported for scanning dblib and ctlib and reporting on the areas which need to be changed to work with Oracle
  Migration Project Estimation Ability to work out a time and resource duration for a database migration project. The project estimation generates a spreadsheet that can be used by Project Managers to customize resource planning to suit their organization
  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
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
  PDF Generation Generate PDF for database objects or data from Connections Navigator, Reports Navigator, DBA Navigator, Database Unload and Data Grid via Unload
  Security Password-protect a pdf document, permission password for security settings and different levels of encryption
  Version Support Version support from SQL Developer 1.5 to latest release
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
Query Builder Query Builder Viewer Visual SQL Query Builder with an object drag and drop feature from the connection navigator or schema browser 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
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
SQL Plus Commands   View all supported SQL Plus Commands
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
TimesTen TimesTen In-Memory Database Support Management of database users. Create and drop users, grant and revoke system privileges, change user passwords
    Pre-defined reports on TimesTen database objects, such as PL/SQL, Table, User and Privileges.
    Support for Synonyms and Materialized View Logs
    View and update column data using custom cell editors
    Gather table and column statistics for all tables belonging to the connection user
    Add or change a PK index to hash index
    Schema browser support for filtering and narrowing the list of objects displayed
    Create cache groups from Oracle synonyms
    Compile invalid or all PL/SQL packages, procedures and functions
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
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