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?
+1
A:
Oracle don't provide a tool for free. Their SQL Developer Modeler is pretty good but price-y if you need to buy a commercial license.
If you are interested in platform independence then Power Architect is FOSS.
APC
2009-08-26 09:21:14
Thanks APC. Sadly, I only have Oracle Sql Developer.
2009-08-26 09:41:55
A:
Oracle Sql Developer is free and have Query builder which can display diagram. You can drag and drop tables from list of tables in schema.
zendar
2009-08-26 09:30:27
Thanks zendar, but I mean show the relationship between tables. Sorry if I am a little vague about this.
2009-08-26 09:42:35
SQL Developer Modeler can do it, but it costs. SQL Developer (not Modeler) is free tool that can show diagram. It works like visual query builder in Ms Access. It does not have functionality like relationship diagram in Ms Access. You can download both and try them.
zendar
2009-08-26 09:46:19
A:
You can connect Access to Oracle via ODBC. Then display the oracle tables in access.
Mark
2009-08-26 13:40:01
A:
There is no inbuilt tool, but you can use some free ware, or even buy some of these if you really like them.
http://stackoverflow.com/questions/674911/light-weight-er-diagram-tool
http://stackoverflow.com/questions/433071/good-tool-to-visualise-database-schema
My personal favorite is ER/Studio
Raj More
2009-08-26 13:41:29
A:
Oracle SQL Developer Data Modeler - Tool recently launched by Oracle.
Schemaspy is good if you require an offline easy to navigate html report.