create or replace procedure BMD5CALCULATE is begin for t in (select from BLACKLIST) loop UPDATE BLACKLIST SET MD5KEY = (SELECt ora_hash(B_30001||B_30002||B_30003||B_30004||B_30005||B_30006||B_30007||B_30008||B_30009||B_30010||B_30011||B_30012||B_30013||B_30014||B_30015||B_30016||B_30017||B_30024||B_30025||B_30026||B_30027||B_30028||B_30029||B_30030||B_30031||B_30032||B_30033||B_30034||B_30035||B_30036||B_30037||B_30038||B_30039||B_30040||B_30041||B_30044||B_30045||B_30046||B_30047||B_30048||B_30049||B_30050||B_30051||B_4021||B_4037||B_4073||B_408||B_4510||B_4511||B_4520||B_4536||B_819||B_831||B_832||B_833||B_CERTIFICATETYPE||B_COMMENT||B_DEALERID||B_ID||B_IDNUMBER||B_NAME||B_ORGID||B_REASON||B_REGISTRATIONTIME||B_TYPE||B_USERID||MD5KEY) as ts from BLACKLIST where B_ID=t.B_ID ) WHERE B_ID=t.B_ID; end loop; end; create or replace procedure MD5CALCULATE is begin for t in (select from CITY) loop UPDATE city SET MD5KEY = (SELECt ora_hash(C_ACTIVEFLAG||C_ID||C_NAME||C_ORGID||C_PROVINCEID||C_ZGFLAG||C_ZIP||MD5KEY) as ts from CITY where C_ID=t.c_id ) WHERE C_ID=t.c_id; end loop; end;