oracle循環插入?
declare j number := 4; k number := 0; cursor cur_get_data is select a1 from TableA;begin for i in cur_get_data loop update TableB set TableB.b2 = i.a1 where TableB.b1 <= j and TableB.b1 >= k; k := j; j := j+ 5; end loop;end ;
oracle循環插入?
declare j number := 4; k number := 0; cursor cur_get_data is select a1 from TableA;begin for i in cur_get_data loop update TableB set TableB.b2 = i.a1 where TableB.b1 <= j and TableB.b1 >= k; k := j; j := j+ 5; end loop;end ;