Database Development

JDeveloper provides several new features that support database development, including a separate Connection Navigator to reduce scrolling and the ability to apply custom filters to any container node in the Schema Browser.

You can now also browse Materialized Views (Snapshots) and Materialized View Logs, and edit table definitions.

You can create and use database connections from within JDeveloper for a variety of tasks:

• Manage all your database objects

• Model and generate database schemas

• Create, edit, and save database schema diagrams

• Design-capture existing schema objects

• Create new objects on diagrams

• Modify existing objects on diagrams

• Generate SQL scripts from diagrams

• Create new objects (CREATE statements)

• Reconcile with existing objects (ALTER statements)

• Create and debug PL/SQL

• Work with offline database objects

• Include object definitions in projects for use while disconnected