测试分页记录时，可以用oracle循环插测试记录

测试分页记录时，可以用oracle循环插测试记录 1.隔行中间是普通sql语句，i为外层循环id。 Oracle begin for i in 8..100 loopINSERT INTO "USER2"."FUN_STO_PRO" ("S_ID","AUDIT_STATUS","CREATE_TIME","UPDATE_USER","UPDATE_TIME")VALUES(i,'1','武敬淋',TO

begin
 for i in 8..100 loop

	INSERT INTO "USER2"."FUN_STO_PRO" (
	"S_ID",
	"AUDIT_STATUS",
	"CREATE_TIME",
	"UPDATE_USER",
	"UPDATE_TIME"
	)
	VALUES
	(
	i,
	'1',
	'武敬淋',
	TO_DATE (
	'2015-06-25 18:48:21',
	'SYYYY-MM-DD HH24:MI:SS'
	),
	'武敬淋',
	TO_DATE (
	'2015-06-25 18:48:21',
	'SYYYY-MM-DD HH24:MI:SS'
	)
	);

 end loop;
end;