查找哪些表中有这条数据?

2010-11-26  张林 

查找哪些表中有这条数据?目标检查housekeeping功能的完整性
COLUMN_NAME: CNTR_ID
VALUE: AUTO100033


select table_name
from user_tab_columns
where column_name ='CNTR_ID'

select 'select count(*) from ' || table_name ||' where cntr_id =''AUTO100033''' ||';'
from user_tab_columns
where column_name ='CNTR_ID';
345°/3458 人阅读/0 条评论 发表评论

登录 后发表评论