时间:2021-07-01 10:21:17 帮助过:14人阅读
测试分页记录时,可以用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
测试分页记录时,可以用oracle循环插测试记录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;