1,作成*.sql文件,使用sqlplus执行,速度快,首推
1.1 作成*.sql
===========sql文件内容=========================
update t1 set f1 = 'aaa' where f2 = 'bbb';
update t1 set f1 = 'ccc' where f2 = 'ddd';
commit;
===========sql文件内容=========================
1.2 执行sqlplus
sqlplus user/pwd@DBName @PATH/*.sql
(或者进入sqlplus后,直接输入:@PATH/*.sql)
2,大批量修正DB时可以考虑使用的PLSQL
create or replace procedure TEST_SH IS
type cd_va is varray(100) of VARCHAR2(100);
type name_va is varray(100) of VARCHAR2(100);
v_bankname name_va;
v_bank_cd cd_va;
begin
v_bankname := name_va('Dummy Bank','Dummy Bank');
v_bank_cd := cd_va('9999','D01');
for i in v_bankname.first .. v_bankname.last loop
--for i in 13..79 loop
DBMS_OUTPUT.PUT_LINE(i);
update t_mst_bank set bank_name = v_bankname(i) where BANK_CD = v_bank_cd(i);
end loop;
commit;
end;
阅读(596) | 评论(0) | 转发(0) |