ALL_TAB_COLUMNS is what you're looking for.

Stephen


-----Original Message-----
From: Das Rama
[mailto:oracledba-ezmlmshield-x79321521.[Email address protected]
Sent: 31 January 2008 16:31
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