Thursday, March 31, 2011

Oracle SQL Developer version 3 is released

It's an improvement over version 2 with support for data models and other features:

Data MiningOracle Data Miner 11g Release 2 GUIOracle 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
ProgramsBasic tasks which could be external procedures, PL/SQL or stored procedures
SchedulesSpecify when and how many times a job is executed
JobsObjects that are scheduled which could be Programs or Chains
Job ClassesGroup jobs for resource allocation and prioritization
ChainsCreate a flow of Chain Steps that are linked together by Chain Rules to create more complex Jobs
CredentialsAssign a username/password pair that is used by jobs to authenticate with a host operating system or Oracle Database
Database destinationsSpecify Oracle database on which remote database job run on
DBA FunctionalityDatabase ConfigurationAbility to review and tune Database configuration and edit initialization parameters
Resource ManagerCreate and prioritize consumer groups and manage resource plans
SecurityDefine audit settings and manage profiles, roles and users
StorageDefine and manage archive logs, control files, datafiles, redo logs, rollback segments and tablespaces
Exporting and ImportingImport DataCustomizable 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 DataCustomizable 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 ControlFile Based DebuggingSet breakpoints in PL/SQL files (.pls, .pkb, etc) and run or debug these files
MenusConnectionsRecompile Schema on a connection
Disconnect All connections
TablesGenerate Table API on the Tables node
MigrationsFull command line supportAll major migration functions can now be run on the command line
Server Capture supportAbility to capture all the databases in a server for SQL Server and Sybase
Project support for MigrationsNew project navigator. All migration tasks are now wizard based to manage the process
Application Scanning and Migration for Sybase DBLIB and CTLIB applicationsThe 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 EstimationAbility 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 ReportsReports for detailed analysis of source objects, converted objects and issues with migrations
Improved identifier and name mappingDefine the names of target objects before the migration starts
PDFCustomizable LayoutsCustomize 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 SupportImages, video, text, doc, spreadsheets, and other objects embedded in the PDF document, or linked as separate files
Document CompressionDifferent levels of document compression
Meta dataMeta data such as title, name, subject and keywords
PDF GenerationGenerate PDF for database objects or data from Connections Navigator, Reports Navigator, DBA Navigator, Database Unload and Data Grid via Unload
SecurityPassword-protect a pdf document, permission password for security settings and different levels of encryption
Version SupportVersion support from SQL Developer 1.5 to latest release
PL/SQL SupportParserCode completion was amended with additional templates automatically derived from PL/SQL and SQL syntax
DebuggingPL/SQL debugging of anonymous blocks
Ref CursorRun and debug procedures with ref cursors
Display ref cursor data
Query BuilderQuery Builder ViewerVisual 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 CreationAutomatically determine and show joins between related tables added to the Query Builder canvas. Can also drag/drop columns to manually create them
Multiple Join TypesJoin properties in clear user terms (“Show all ”) remove confusion with LEFT OUTER, RIGHT FULL, etc. syntax
Grouping, Predicates, SortingColumn visibility, alias name, grouping, sorting and selection predicates are shown in an easy to use table layout
Derived Tables, Sub-Queries, and UnionsDerived 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
SpatialSpatial Data ManagementIdentify 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
TimesTenTimesTen In-Memory Database SupportManagement 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
TuningSQL Tuning AdvisorAnalyzes submitted high-volume SQL statement and offers tuning recommendations
Diff Tool for Explain PlansCompare selected Explain Plan or Autotrace results for any SQL statements.
Management Pack Licensing PreferencesPreferences 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

Oracle SQL Developer