How to visualize the relationship of tables in an Oracle database

database oracle visualization entity-relationship
Jimmy picture Jimmy · Aug 26, 2009 · Viewed 31.9k times · Source

I know in Access there is a way I can visualize the relationship between tables in a diagram - kind of like an ER diagram.

I am new to Oracle. I am wondering if I can do the same/similar thing with Oracle. Could someone give some suggestions?

Answer

Santosh Gokak picture Santosh Gokak · Aug 26, 2009

Oracle SQL Developer Data Modeler - Tool recently launched by Oracle.

Schemaspy is good if you require an offline easy to navigate html report.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENT_LOG that contains eventID, eventType, eventDesc, and eventTime, then I would …

Read More