how to find a certain column in all tables in a database? 1

[wvdba]

hi.
i'm in the process of making some changes to a number of tables in a database. is there a way to find if a certain column (col_name) exists in any table in the database?
thanks again.

 

[Turkbear]

Hi,
Look here for info on ALL_TAB_COLS and ALL_TAB_COLUMNS

http://download.oracle.com/docs/cd/B13789_01/server.101/b10755/statviews_1179.htm

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[wvdba]

thank you so much turkbear.
that helped a lot. it was what i was looking for.
you deserve a star.

 

[Turkbear]

Hi,
Thanks, Glad to help.
This site saved me often when I was an Oracle DBA:

http://www.oracle.com/technetwork/indexes/documentation/index.html

To Paraphrase:"The Help you get is proportional to the Help you give.."