When testing paging records, you can use oracle loop insert test records

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;