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 for na earlier version for 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 schema in JDeveloper (here we choose an arbitrary application)
- in Applications Navigator create an application that uses all technologies.
- Right-click on Project ->New->Database Tier->Offline Database Objects-> Database Diagram->OK
- Accept defaults in CreateDatabase Diagram
- Open Connection to 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 - 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