declare

v_id tbl_regions.regions_id%type;

begin

for  v_i in .. loop

select t.regions_id into v_id from  tbl_regions t where t.regions_id=v_i;

dbms_output.put_line(v_id);

update tbl_regions s set s.regions_sort = v_id  where s.regions_id=v_i;

end loop;

end;

declare

v_i int:=;

v_j int:=;

begin

while v_i< loop

v_j:=;

while v_j<=v_i loop

dbms_output.put(v_j||'*'||v_i||'='||v_i*v_j||' ');

v_j:=v_j+;

end loop;

dbms_output.put_line('');

v_i:=v_i+;

end loop;

end;