创建表

create table TX_TEST

(

ID NUMBER not null,

NAME VARCHAR2(200),

URL VARCHAR2(300),

POSITION VARCHAR2(200),

CREATETIME DATE

)

编写脚本

declare

-- Local variables here

count integer;

begin

-- Test statements here

dbms_output.put_line('start:'||sysdate);

for count in 1..1000000 loop

insert into tx_test

values (count,'aa'||count,'https://www.baidu.com?id='||count,'Chinese-'||count,sysdate);

commit;

end loop;

dbms_output.put_line('end:'||sysdate);

end;