Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fuzzy search across DB table columns

d1556254-8a5a-4ebe-b20c-8cf42d623d9aFeb 23 2015 — edited Feb 23 2015

Hi,

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.

my query:

     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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2015
Added on Feb 23 2015
1 comment
409 views