-
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.
sree
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|