oracle 中怎么实现100次循环插入，并且其中一列自增1

create or replace procedure p_test (i_str in varchar)is

v_str varchar2(100)

i number

begin

select i_str into v_str from dual

i:=0

for i in 1..100 loop

insert into test

select i,'00'

from dual

end loop

commit

end p_test

insert into abook2 values (idx, val + idx)

Oracle 字符串连接, 不用 + , 用的是 ||

insert into abook2 values (idx, val || TO_CHAR( idx ) )

---