Re: Find database objects in Oracle

> Hi Guys,
> Thanks for your replies. I want to insert a physician into a table. I
> have no idea where this table is located, the database is massive. So
> in SQL Server I would find the column name using the object browser. I
> would guess that the column has the string %phy% and it would return
> all the tables that have a column with %phy% in it. It is a very
> powerful tool and I hoping it exists in Oracle.

[Quoted] "want to insert..."

"no idea where this table is located"

"you would guess"

Wouldn't it make more sense to actually get someone to explain the database to you before you start inserting data?

-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com