Select table_name , owner , data_type from all_tab_columns where
column_name = 'COLUMNNAME' ;



Kedar Barde

Oracle 9i DBA

Oracle Certified Associate(OCA)

Email: kedar.[Email address protected]



-----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.


"Any of the statements or comments made above should be regarded as personal and not necessarily those of Velindre NHS Trust, any constituent part or connected body

Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol ac nid o reidrwydd fel datganiadau neu sylwadau gan Ymddiriedolaeth GIG Felindre, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig a'r Ymddiriedolaeth".


Oracle LazyDBA home page