Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I wonder if someone can help.
I am trying to do a fuzzy search across all the tables in DB to return the column_name.
select table_name from all_tab_columns
where column_name ='...';
The above only returns rows if I query the specific column name, but instead I would like to return values only if for example column name begins with ABC.
where column_name LIKE 'ABC%' is what you want, it sounds like.
This is a better question for the SQL & PL/SQL Community though.