If you don't have DBA privileges, you can try this:
select table_name from dba_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';
select table_name from all_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';
John Mcginnis wrote:I'm sure you guys had a Toad review to understand how things are done there.....so
The quick search field in the schema browser is doing client-side filtering of the list of objects. This means we can only filter on things that we already have fetched from the database, like the object name. We have no current plans to extend the types of information that can filter on, although it is possible we might add the ability to filter based on a few other types of information that we generally fetch with the object name. However, filtering by column name would require pre-fetching the lists of columns for all tables and as such is not likely to be added to the schema browsers search field.