CREATE TABLE T_TEST(ID INT,NAME VARCHAR(30),LONGTIME DATETIME) ;
begin
for i in 1..200
Loop
insert into t_test(id, name, longtime)
select rownum,dbms_random.string('a',30), sysdate -numtodsinterval(i, 'minute')
from SYS.SYSDUAL
CONNECT by rownum <=100000;
print(i||SQL%ROWCOUNT);
commit ;
end loop;
end