本文共 928 字,大约阅读时间需要 3 分钟。
创建一个序列
然后创建一个触发器,每次插入数据的时候,将主键自动加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');
就不必写主键了
转载地址:http://rsupi.baihongyu.com/