oracle 想让新增的列自增的方法

思路：先增加序列，再创建触发器，然后选择数据增加。

序列中设置起始值，步长，触发器中赋值

insert into table1(ztid,
dddyflmc,
CKID,
bz,
ztflag,
cuser,
uuser,
CDATE,
UDATE,
dddyfzid )  

select ztid,
dddyflmc,
5,
bz,
ztflag,
cuser,
uuser,
TO_DATE('2018-10-15','YYYY-MM-DD'),
TO_DATE('2018-10-15','YYYY-MM-DD'),
dddyfzid from table1 where ckid=4

SELECT * FROM  table1where ckid=5
DELETE table1 where ckid=5

-- 创建序列
create sequence sq_items
-- 自增步长
increment by 1
-- 始值
start with 49 
-- 没有最大值
nomaxvalue 
-- 不循环
nocycle; 
create sequence sq_items2
-- 自增步长
increment by 1
-- 始值
start with 49 
-- 没有最大值
nomaxvalue 
-- 不循环
nocycle; 

DROP TRIGGER itmes_trig;
DROP sequence sq_items;
--创建触发器，将序列与表的字段关联起来，并实现自增
create or replace trigger itmes_trig
before insert on table1
for each row
declare
begin
 select sq_items.nextval into :new.dddyflid from dual;
  select sq_items2.nextval into :new.dddyflbh from dual;
end items_trig;