1 Reply Latest reply on Feb 23, 2015 2:15 PM by thatJeffSmith-Oracle

    Fuzzy search across DB table columns

    d1556254-8a5a-4ebe-b20c-8cf42d623d9a

      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.