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

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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;