oracle 一次插入10万条数据

假如test表有丙从此字段，分别别日期时间和ID

insert into test select sysdate,rownum from dual connect by level <= 100000;