触发器 在表二插入数据时
create or replace trigger Splitsingle before insert
on 表体
for each row
begin
if :new.seq=2
then
insert into xxx select id+:new.seq,sid+:new.seq,.... from xxx where id = pid;
:new.pid = :new.pid+2;
elsif :new.seq>2
insert into xxx select id+(:new.seq-1),sid+:new.seq,.... from xxx where id = pid
:new.pid = :new.pid+:new.seq;
end if;
end;
大概就这个样子
oracle 修改id可以直接在查询后面加吗?