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;
/
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 vTa...