oracle大量插入数据

来源：互联网发布：看上期尾数知下期尾数编辑：程序博客网时间：2024/04/30 01:40

创建一个序列

然后创建一个触发器，每次插入数据的时候，将主键自动加1

 create or replace trigger insert_tri

 before insert on MS_BINSYU  for each row    declare

 begin

    select SEQ_BINSYU_ID.nextval into :new.binsyuid from dual;    end;

binsyuid--主键
SEQ_BINSYU_ID--> 是序列

插入语句

Insert into MS_BINSYU (KIGYOID,SOKOCD,NINUSICD,BINSYUNM,UNSOUGYOSYACD,BINSYURKNM,YUSOSYUDAN,BINSYULBL,BINSYUCD_HJYO,CYOHYOPRTUSNJYN1,CYOHYOPRTUSNJYN2,CYOHYOPRTUSNJYN3,DATATOROKUMOTOKBN,TORIID,RTNTEISIFLG,SAKUJOFLG,SYOKAITOROKUDATE,SYOKAITOROKUUSRID,LASTKOSINDATE,LASTKOSINUSRID,EXCLCNT,TOROKUDATE,TOROKUUSR,TOROKUTRM,TOROKUPRGRM,KOSINDATE,KOSINUSR,KOSINTRM,KOSINPRGRM) values (1,'1','1','便種名称01','0001','略称01','01',3,'02',11,22,33,'0 ',null,'0','1',to_date('14-11-27','RR-MM-DD'),11111111,to_date('14-12-08','RR-MM-DD'),11111111,3,to_date('14-11-27','RR-MM-DD'),'11111111','0:0:0:0:0:0:0:1','WmsMaD035D01',to_date('14-12-08','RR-MM-DD'),'11111111','0:0:0:0:0:0:0:1','WmsMaD036D01');

就不必写主键了

0 0