Features marked with **, have been added since the Evaluation
Release 1(1.1.0.21.97)
| Focus Area |
Feature Area |
Description |
| Object
Navigator |
Browse Objects |
Advanced filtering |
| |
|
Filtering incorporates AND or OR filtering |
| |
|
Allow sortability through column headings |
| |
|
Details Tab: Display create date and last DDL for all objects |
| |
|
Increased search capabilities |
| |
|
Updated Object Navigator for improved object browsing and
navigation |
| |
Column Sequences |
Can now add sequences with triggers for
any column, not just Primary Key |
| |
Database Links |
View public database links |
| |
Directories |
View details |
| |
Domain Indexes |
Create an index on any existing indextype from any accessible schema |
| |
Materialized Views |
Advanced checkbox: Select statement to be
defined declaratively by choosing select items, from objects etc |
| |
|
Advanced checkbox: Indexing |
| |
|
Advanced checkbox: Partitioning |
| |
|
Can index MVs using "New Index" |
| |
Materialized View Logs |
New UI for creating and editing MV Logs |
| |
Messages |
Improve Error Display, make more specific
to Oracle |
| |
|
On Compile, display a success message in
the status bar |
| |
Package / Object Type Bodies |
Default skeletal implementation from the spec for "Create
Body" |
| |
PL/SQL |
Added line number toggle to read-only code view |
| |
|
Compile all invalid objects |
| |
|
Compile all |
| |
|
File based PL/SQL support |
| |
Sequences |
Sequences, Added right-click to alter sequence |
| |
Tables |
Browse data ( with XMLType columns) |
| |
|
View CLOB data |
| |
|
Disable related FK constraints |
| |
|
Enable related FK constraints |
| |
|
Triggers tab: Also displays trigger code |
| |
Users |
Create user with grants and roles etc |
| |
|
Edit user roles, grants and privileges |
| |
Views |
Compile Invalid |
| |
|
Update data in updatable views |
| |
XML Schema |
Read-only support for XML Schema |
| PL/SQL
Parser updates |
PL/SQL Parser updates |
Increased PL/SQL and SQL editing support,
including improved parsing capabilities such as the following: |
| |
|
Fix: FOR UPDATE and ORDER BY clauses can
be in either order |
| |
|
Support for NTile function |
| |
|
Insert statement support: The syntax supports
an optional column list between INSERT and VALUE |
| |
|
select cast('11-oct-2006' as timestamp)
from |
| Import
and Export |
Import Data |
Import data from spreadsheet (CSV or XLS format) into a table
using SQL Developer |
| |
Export Data |
Export data for more than one table at a
time (with or without DDL) |
| |
|
Export data to spreadsheet from a table
( to XLS) |
| |
|
Export to HTML |
| |
Export DDL |
Export DDL to include drop object |
| |
|
INSERT data statement for multiple tables |
| |
|
Option to export 'All My Objects' (expand other users and
select check user) |
| |
|
Option to suppress schema name |
| Connections |
Connections |
Can now Save connection without closing
dialog |
| |
|
Creating Connections Dialog updated |
| |
|
Save an "empty" connection |
| |
|
TNS connections don't expand out |
| |
|
Read-only Third Party connections added for MySQL and
SQL Server ** |
| General |
Search Engines |
Oracle doc |
| |
|
Search AskTom |
| |
|
Search Doc10.2 |
| |
|
Search Doc9i |
| |
|
Search Forums |
| |
|
Search Google |
| |
|
Search Metalink |
| |
|
Search Oracle |
| |
Performance |
Ongoing updates to improve performance |
| |
Preferences |
Added preference to display value instead of NULL values |
| |
|
Additional user preferences for controlling the SQL Developer
environment |
| |
|
Allow fetch size to be greater than 5000 |
| |
|
Auto-freeze/pin tab |
| |
|
NLS Date Format & other NLS parameters |
| |
|
Open SQL worksheet on connect |
| |
|
Redirect profile away from default User Home |
| |
|
Set default path for file execution |
| |
|
SQL Array Fetch size |
| |
|
Object Viewer Parameters: Additional parameters to control
DDL on the SQL tab |
| |
|
Update NLS parameters |
| |
|
Share user defined reports |
| |
Menu |
Added External Tool (Defaults) |
| |
|
Added other External Tools |
| |
|
F3 assigned to Find Next |
| |
|
Schema diff -(Is not functional in build 1.1.0.22.71)** |
| SQL
Worksheet |
Data Grids |
Added duplicate record button |
| |
|
Added single record "pivot" to view and edit one
record at a time |
| |
|
Allow columns to be reordered in SQL Worksheet and recall
previous order |
| |
|
Calendar prompt for date fields in table data editor |
| |
|
Context Menu on grids |
| |
|
Count Rows with filter |
| |
|
Improved data grid navigation |
| |
|
Auto resize column widths (on context menu on the data grid
and column header) |
| |
Query Builder |
Create basic query |
| |
|
Run query to test data |
| |
|
Transfer SQL to SQL Worksheet |
| |
Snippets |
Create new category |
| |
|
Create new snippet |
| |
|
Make Snippets manageable by the user, edit snippets |
| |
SQL Worksheet |
Added BLOB support in SQL Worksheet and
Reports |
| |
|
Added file browsing support |
| |
|
Additional SQL statement formatting in the
SQL Worksheet |
| |
|
Allow for report and form view of SQL query
results in the worksheet |
| |
|
Better support for displaying output of
ref cursors |
| |
|
CLOB, xml, cursor support |
| |
|
Describe a table using a short cut key |
| |
|
Name the tabs: set worksheetname 'MyTab
Name' |
| |
|
Ongoing expansion of SQL*Plus support |
| |
|
Pause long running script |
| |
|
Resume paused script |
| |
|
Select entire row by selecting rownum |
| |
|
Set pause off |
| |
|
Support for Times Ten |
| |
|
Support for XQuery in the SQL Worksheet |
| |
|
Updatable views should allow insert, update
and delete as for tables. |
| |
|
Update look of Explain Plan |
| |
|
Code insight on table alias |
| |
SQL Plus Commands |
Autotrace |
| |
|
Host |
| |
|
Pause |
| |
|
Echo |
| |
|
Feedback |
| |
|
Term |
| |
|
Timing |
| |
|
XQuery |
| |
|
Errors |
| |
|
User |
| |
Tuning |
Autotrace support |
| |
|
Improved explain plan support |
| Reports |
Reporting |
Allow for Import and Export of user defined reports |
| |
|
Database Session Browsing through master - detail reports |
| |
|
Export all reports |
| |
|
Import all reports |
| |
|
Increased right click actions |
| |
|
Kill Session |
| |
|
SQL Reporting |
| |
|
Trace Session |
| |
User Defined Reports |
Charting (select group,series,data from
table) |
| |
|
Copy shipped reports and paste as user defined
reports |
| |
|
Create & Run chart report |
| |
|
Create & Run master detail reports |
| |
|
Create a report using a script |
| |
|
Create a report with plsql-dbms_output
e.g. begin dbms_output.put_line('<h1>hello</h1>'); end; |
| |
|
Create a reports with code ( e.g. select
text from user_source where rownum < 100 ) |
| |
|
Click through user defined reports |
| |
|
Define prompt for bind var |
| |
|
Drill down links |
| |
|
Creating a User Defined Report,
allow user to browse and bring in a file to populate the SQL |
| |
|
Share User defined reports |
| |
|
Increase the size in the
SQL area for user defined reports |
| |
|
Open user defined reports
created in 1.0 |
Bookmark
