In JDeveloper you can design, model and generate database tables
This page explains how to view a database schema in JDeveloper. For a detailed explanation of how to model and generate new tables in addition to the tables in your schema, see the Oracle technology page (apparently for an earlier version of JDeveloper, but in principle works on 10.1.3 and up): http://www.oracle.com/technology/obe/obe9051jdev/dataModeling/lesson_dm.htm
The main idea is that you want to import tables from a database into offline database tables, manipulate tables and than create an SQL data definition languagage file which can be used to update tables in the oracle database.
Here are the steps leading to a view and printing of a schema in JDeveloper (we choose an arbitrary application)
- In Applications Navigator create an application that uses template 'All technologies'
- Right-click on Project ->New->Database Tier->Offline Database Objects-> Database Diagram->OK
- Accept defaults in CreateDatabase Diagram
- Open Connection to the database schema whose tables you want to view (Connections->Database>Schema->Tables in Connections Navigator)
- Highlight all the tables you want to see (Ctrl-click adds to choices)
- Drag and Drop tables on the Database Diagram (Create From Database Object dialog appears - accept default Offline Database Objects)
- Play with/change tables
- Right-click on the database diagram panel -> Publish Diagram
- Choose location of the newly created png image.
- See an example of a schema in the attached file.