This pulls every time a specific column comes up in any schema. To use
your own schema either specify in the where clause OWNER - 'schema name
here' or current schema - change table name from all_cons_columns to
user-cons_columns.

If you are looking for foreign key constraints then another sys view can
be used.

SELECT * from all_cons_columns
WHERE COLUMN_NAME = 'insert column name here in single quote'


James Clark


-----Original Message-----
From: Das Rama
[mailto:oracledba-ezmlmshield-x79321521.[Email address protected]
Sent: Thursday, January 31, 2008 11:31 AM
To: LazyDBA Discussion
Subject: Looking for column name in the whole database


Good morning experts,

We are on Oracle 9i, I need to know if there is a view from which I
could select a certain column name and all the tables it is associated
with. If not, please could someone help me with the SQL to this.

Thanks in advance. Like, always all answers and pointers are highly
appreciated.

RAMA DAS,
HFM US.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page