Search Oracle DBA Sql Query

 SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%PAPER%';

Search All Fields In All Tables For A Specific Value (Oracle)

SELECT * from dba_objects WHERE object_name like '%PAPER_FORMAT%' ;

SELECT table_name, column_name FROM all_tab_cols where column_name LIKE '%PAPER%';

variable val varchar2(10)
exec :val := 'KING'

SELECT DISTINCT SUBSTR (:val, 1, 11) "Searchword",

      SUBSTR (table_name, 1, 14) "Table",

      SUBSTR (column_name, 1, 14) "Column"

   FROM cols,

     TABLE (xmlsequence (dbms_xmlgen.getxmltype ('select '

      || column_name

      || ' from '

      || table_name

      || ' where upper('

     || column_name

     || ') like upper(''%'

     || :val

     || '%'')' ).extract ('ROWSET/ROW/*') ) ) t

   ORDER BY "Table"

/

variable val NUMBER
exec :val := 20

SELECT DISTINCT SUBSTR (:val, 1, 11) "Searchword",
     SUBSTR (table_name, 1, 14) "Table",
      SUBSTR (column_name, 1, 14) "Column"
    FROM cols,
     TABLE (xmlsequence (dbms_xmlgen.getxmltype ('select '
     || column_name
     || ' from '
      || table_name
      || ' where upper('
     || column_name
     || ') like upper(''%'
    || :val
     || '%'')' ).extract ('ROWSET/ROW/*') ) ) t
   ORDER BY "Table"