Oracle SQLDeveloper: how to search which tables have a column matching a given query?

Question

In SQL Developer, how do I find which table has a column that matches a given search query?

+3

zer0stimulus Jan 29. 13 at 19:05

1 answer

igr · Accepted Answer · 2013-01-29T19:13:25+0000

Select table_name, column_name 
from user_tab_columns 
where column_name like '%'|| '&columnPattern' || '%'

User_tab_columns

for your own tables. Otherwise, or dba_tab_columns

all_tab_columns