DECLARE
X NUMBER(3);
Y NUMBER(3);
V_COUNTER NUMBER(2);
v_str VARCHAR2(1000);
BEGIN
X := 1;
v_str := 'insert into user_info values((select (max(USERID) + 1) from USER_INFO),''aa'',''aa'',0,''2007-09-12'',''hong@163.com'',''0'',''demo'')';
FOR V_COUNTER IN 1 .. 1000 LOOP
--begin
insert into user_info values((select (max(USERID) + 1) from USER_INFO),'aa','aa',0,'2007-09-12','hong@163.com','0','demo');
--DBMS_SQL.EXECUTE(v_str);
--exec immediate v_str;
--IF V_COUNTER = 4 THEN
--GOTO end_of_loop;
--END IF;
--X := X + 10;
--end;
END LOOP;
--<<end_of_loop>>
Y := X;
--dbms_output.put_line('Y:'||Y);
commit;
END;
X NUMBER(3);
Y NUMBER(3);
V_COUNTER NUMBER(2);
v_str VARCHAR2(1000);
BEGIN
X := 1;
v_str := 'insert into user_info values((select (max(USERID) + 1) from USER_INFO),''aa'',''aa'',0,''2007-09-12'',''hong@163.com'',''0'',''demo'')';
FOR V_COUNTER IN 1 .. 1000 LOOP
--begin
insert into user_info values((select (max(USERID) + 1) from USER_INFO),'aa','aa',0,'2007-09-12','hong@163.com','0','demo');
--DBMS_SQL.EXECUTE(v_str);
--exec immediate v_str;
--IF V_COUNTER = 4 THEN
--GOTO end_of_loop;
--END IF;
--X := X + 10;
--end;
END LOOP;
--<<end_of_loop>>
Y := X;
--dbms_output.put_line('Y:'||Y);
commit;
END;