Database Modeling Tools in JDeveloper

• You can work with database objects in the following ways:

• Online: Create and modify schema objects directly in a database through a JDeveloper connection.
• Offline:
• Model metadata for database objects outside the context of a database schema.
• Import objects from online database.
• Generate changes to online schemas.
• Diagrammer:
• Create and modify objects by dragging from Component Palette and Database Navigator.
• Import objects from offline database model.
• Generate changes to online schemas.

Notes:

Database Modeling in JDeveloper

You can use JDeveloper to work directly with database objects through a database connection. Alternatively you can work with offline database definitions, which you can subsequently generate to a database schema.

JDeveloper provides the tools you need to create and edit database objects such as tables and constraints outside the context of a database. You can create new tables and views and generate the information to a database, or you can import database objects from a database schema, make the changes you want and then generate the changes back to the same database schema, to a new database schema, or to a file that you can run against a database at a later date. Alternatively, you can use JDeveloper’s modeling tools to visualize your offline database objects on a diagram.

You can use JDeveloper’s database diagrammer to design and create new tables as well. You can import database objects from the offline database into the diagrammer. The diagrammer allows you to import database objects from online schemas and also generate changes to online schemas.