Function to find specific value in any table any column
Steps to use the following function: Replace the string highlighted in bold/red , with the string you want to search. Note: the following function is tested & working fine in Oracle DB. declare cursor c1 is select column_name , table_name from user_tab_columns where data_type = 'VARCHAR2';-- and table_name = 'REV_DIM_ATTRIBUTES_B' ; vSQL varchar2(32676) := null; vParam varchar2(100) := '10.184.75.23' ; vcnt number; begin for x in c1 loop begin vSQL := 'select count(*) from '||x.table_name||' where '||x.column_name||' like '||chr(39)||'%'||vparam||'%'||chr(39); execute immediate vSQL into vcnt; if vcnt > 0 then dbms_output.put_line('Found in '||x.table_name||' '||x.column_name); end if; exception when others then dbms_output.put_line('Problem in '||vSQL); ...