17,086
社区成员
发帖
与我相关
我的任务
分享
DECLARE v_tablename varchar2(50);
v_sql varchar2(4000);
begin
FOR v_tablename in ( select distinct table_name from user_tab_columns where COLUMN_NAME ='NUMBERCODE') LOOP
BEGIN
v_sql := ' UPDATE' || v_tablename || ' SET NUMBERCODE = 90 WHERE NUMBERCODE =23 ';
--DBMS_OUTput.put_line(v_sql);
execute immediate v_sql;
END;
END LOOP;
END;