。。。我没有直接去更新你的表。你要看清楚我上面说的话
“ ---如果该表有那内容的就打印那个表的update语句。”declare
l_cnt varchar2(20);
v_sql varchar2(4000);
v_tablename varchar(200);
cursor cursor_jsdx is select 'select count(*) from ' || table_name || ' where BANK_ACC=''000000''',table_name from user_tab_columns where column_name='BANK_ACC';
--注:这里的字段名要大写
begin
open cursor_jsdx;
Loop
fetch cursor_jsdx into v_sql,v_tablename;
exit when cursor_jsdx%notfound;
execute immediate v_sql into l_cnt;
if l_cnt >0 then
---如果该表有那内容的就执行update语句。(没测试过不保证成功)
execute immediate 'update ' || v_tablename || ' set BANK_ACC=''111'' where BANK_ACC=''000000''';
end if;
end loop;
Close cursor_jsdx;
end;