When testing paging records, you can use oracle loop insertion test records 1. The middle of the line is a common SQL statement, and I is the outer loop id. Oraclebeginforiin8.. 100loopINSERTINTOUSER2. FUN_STO_PRO (S_ID, AUDIT_STATUS, CREATE_TIME, UPDATE_USER, UPDATE_TIME) VALUES (I, 1, Wu Jinglin,
When testing paging records, you can use oracle loop insertion test records 1. The middle of the line is a common SQL statement, and I is the outer loop 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', 'wu jinglin',
When testing paging records, you can use oracle loop insert test records
1. The middle of the line is a common SQL statement, and I is the id of the outer loop. 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', 'wu jinglin ', TO_DATE ('2017-06-25 18:48:21 ', 'syyyy-MM-DD HH24: MI: ss'), 'wu jinglin', TO_DATE ('2017-06-25 18:48:21 ', 'syyyy-MM-DD HH24: MI: ss'); end loop; end;