菜鸟提问:在SQL*Plus中为什么不能创建两个触发器?

[md5e]

/*创建序列*/
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;

[oracledbalgtu]

新起一行，用"/"结束


[Quote=引用楼主 liuchaolin 的帖子:]
/*创建序列*/
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 …
[/Quote]

[md5e]

哦，谢了,结贴