/*创建序列*/
create sequence seq_accideent_id increment by 1 start with 1 nomaxvalue nocycle;
create sequence seq_Die_id increment by 1 start with 1 nomaxvalue nocycle;
create sequence seq_Hug_id increment by 1 start with 1 nomaxvalue nocycle;
/*创建触发器*/create or replace trigger trigger_autoinc_accident
before insert on accident
referencing old as old_value new as new_value
for each row
declare
iSeq integer;
begin
select seq_accideent_id.nextval into iSeq from dual;
new_value.ItemId= iSeq;
end;/*请问结束上一个触发器的语句是什么*/
create or replace trigger trigger_autoinc_Die
before insert on Die
referencing old as old_value new as new_value
for each row
declare
iSeq integer;
begin
select seq_Die_id.nextval into iSeq from dual;
new_value.ItemId= iSeq;
end;
create sequence seq_accideent_id increment by 1 start with 1 nomaxvalue nocycle;
create sequence seq_Die_id increment by 1 start with 1 nomaxvalue nocycle;
create sequence seq_Hug_id increment by 1 start with 1 nomaxvalue nocycle;
/*创建触发器*/create or replace trigger trigger_autoinc_accident
before insert on accident
referencing old as old_value new as new_value
for each row
declare
iSeq integer;
begin
select seq_accideent_id.nextval into iSeq from dual;
new_value.ItemId= iSeq;
end;/*请问结束上一个触发器的语句是什么*/
create or replace trigger trigger_autoinc_Die
before insert on Die
referencing old as old_value new as new_value
for each row
declare
iSeq integer;
begin
select seq_Die_id.nextval into iSeq from dual;
new_value.ItemId= iSeq;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货