Hi,
One of my developer asked me to write one program to find out a value in the whole schema. For that i wroted this program.

set pagesize 0
set feedback off
set heading off
set verify off
spool test1.sql
SELECT 'SELECT '||''''||table_name||'--'||COLUMN_NAME||'--'||''''||'||'||' COUNT
(*) FROM
'||TABLE_NAME||' WHERE '||COLUMN_NAME||' LIKE '||''''||'%3136%'||''''||';'
FROM USER_tAB_COLUMNS;
spool off;
spool test_result.sql
@test1.sql
spool off;

This query giving me the table name and count of rows, Is there any other way to solve this problem.