Using the Database Navigator
The Database Navigator provides you with a complete editing environment for online databases. You can use it to create, update and delete database objects. Much of the functionality available standalone in SQLDeveloper is also available in JDeveloper. Highlights include:
SQL Worksheet: Script execution, explain plan, autotrace, code snippets (drag and drop), DBMS and OWA output
Creation of external, index organized, temporary, partitioned (range, hash, and list) tables and materialized views
Extensive context menu options to modify objects (for example, table rename, column additions, compilation, index rebuilds, database link testing)
Browse, query, update, delete, sort, and filter data including CLOB and BLOB and tracking of changes through message log
Export data in multiple formats; export DDL; import data
Database reports