I don't know the real name of that application but what i want to do is so simple, i have an oracle database with more than 50 tables. I want to get their names also their field names, so i thought that it would be nice to use a designer or something like mssql has. Then i can get the field names and table names easily. How can i do that?
Thanks for the help, Mehmet Şerif Tozlu
If by "getting table and field names" you mean, inside a program, you need to use Oracle's METADATA through any METADATA API you feel more comfortable with: JDBC, ADO.NET, ODBC, or even performing queries against METADATA tables (user_tables, all_tables, etc).
If by "getting table and field names" you mean a visual tool to inspect them, there are a lot of them.
Hope it helps.
Instead of outputting all 50 tables and all columns all at once, what you may want to do is to generate several diagrams, each containing tables for a functional part of your system. In a hypothetical system, this could be "client and accounts", "bank transactions", and so on. Some tables may appear in multiple diagrams. Not all columns may need to be outputted, especially if they do not belong to a particular functional area of your system.
You can use SchemaCrawler for Oracle. SchemaCrawler allows you to search for and only output tables and columns that match a regular expression, as well as to generate database diagrams, with the help of GraphViz. It also find implied relationships between tables if the schema uses a naming convention.