思路:先增加序列,再创建触发器,然后选择数据增加。
序列中设置起始值,步长,触发器中赋值
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;