create or replace procedure add_modifierid_foruserchanhis is
vSql varchar2(500);
vSql4 varchar2(500);
vTable varchar2(50);
begin
for m in 0..9 loop
for n in 0..9 loop
vTable := 'user_info_history_'||m||'_'||n;
vSql := 'alter table ' || vTable || ' add modifierID VARCHAR2(40)';
vSql4:='comment on column ' || vTable || '.modifierID is ''修改人ID''';
/*dbms_output.put_line(vSql);
dbms_output.put_line(vSql4);*/
execute immediate vSql;
execute immediate vSql4;
commit;
end loop;
end loop;
end add_modifierid_foruserchanhis;
/
存储过程(一)批量添加字段
最新推荐文章于 2023-05-12 19:45:00 发布