it would be nice if you precised, with what is the required column specific. E.g. with its name, data type, number of occurrences in different tables, or something totally different?
Anyway, all column properties mentioned by me for current user are available from querying USER_TAB_COLUMNS view. Similarly, ALL_TAB_COLUMNS shows all columns the current user is privileged to see, DBA_TAB_COLUMNS covers whole database.