It's an improvement over version 2 with support for data models and other features:
| 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 | |
| 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 | |
| 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 | ||
Download:
Oracle SQL Developer
