In JDeveloper you can design, modeling and generate database tables
This page explains how to view a database schema in JDeveloper. For detailed explanation of how to model and generate new tables in addition to the tables in your schema, see the Oracle technology page (aparently apparently for na earlier version for of JDeveloper, but in principle it 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 an offline database tables, manipulate tables and than create an SQL *.dll file which can be used to update tables in the oracle database.
Here are the steps leading to a view and print the current printing of a schema in JDeveloper (here we choose an arbitrary application)
- in In Applications Navigator create an application that uses all template 'All technologies.'
- RightRight-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/change with tables
- Right-click on the database diagram panel -> Publish Diagram
- Choose location of the newly created png image.
- Here is an example of a schema
...