Oracle 批量给某一列循环加数例如从1加到100
DECLARE???????code number(8) := 1; ???????str_old varchar(5) := '1'; ???????str_new varchar(5) := ''; ???????data_id varchar(50) := ''; BEGIN?FOR code IN 1..2234 LOOP?? --从00001循环插入到02234 ?????str_old := '' || code; ???str_new := ''; ???--取出每条数据的主键ID ???select id into data_id from ( ??????????select id, shortname_code, rownum rm from t_system_org ???) v where v.rm = code; ???--判断字符长度，设定str_new的值 ???IF length(str_old) = 1 THEN?????str_new := '0000' || str_old; ???ELSIF length(str_old) = 2 THEN?????str_new := '000' || str_old; ???ELSIF length(str_old) = 3 THEN?????str_new := '00' || str_old; ???ELSIF length(str_old) = 4 THEN?????str_new := '0' || str_old; ???ELSE?????str_new := str_old; ???END IF; ??--根据ID执行更新 ??update t_system_org t set t.shortname_code = str_new where id = data_id; ??commit; ?END LOOP; END;

DECLARE
?????? code number(8) := 1;
?????? str_old varchar(5) := '1';
?????? str_new varchar(5) := '';
?????? data_id varchar(50) := '';
BEGIN
?FOR code IN 1..2234 LOOP

?? str_old := '' || code;
?? str_new := '';
?? --取出每条数据的主键ID
?? select id into data_id from (
????????? select id, shortname_code, rownum rm from t_system_org
?? ) v where v.rm = code;
?? --判断字符长度，设定str_new的值
?? IF length(str_old) = 1 THEN
???? str_new := '0000' || str_old;
?? ELSIF length(str_old) = 2 THEN
???? str_new := '000' || str_old;
?? ELSIF length(str_old) = 3 THEN
???? str_new := '00' || str_old;
?? ELSIF length(str_old) = 4 THEN
???? str_new := '0' || str_old;
?? ELSE
???? str_new := str_old;
?? END IF;
? --根据ID执行更新
? update t_system_org t set t.shortname_code = str_new where id = data_id;
? commit;
?END LOOP;
END;