如题,我创建的触发器如下,请问可不可以同时修改多个值,比如下面的例子,id1,id2,di3create trigger "tri_test"
before insert on test for each row
begin
select seq_test.nextval into :new.id1,new.id2,new.id3 from dual;
end tri_test;
谢谢大家了!
before insert on test for each row
begin
select seq_test.nextval into :new.id1,new.id2,new.id3 from dual;
end tri_test;
谢谢大家了!
解决方案 »
- 求解决 ora-02778 name giver for the log directory is invaild
- 日期格式转换问题
- OracleDataAdapter如何填充实现2个父子表
- ora-00600 错误,急!
- 字符串如何转化成日期类型
- 如何 备份 oracle 10g 的数据???
- 设置帐户登陆次数的问题
- 请教一个简单的SQL问题
- send one complex porblem on 'sql ' to our friends ,come here plese,baby,baby!!
- occi 创建CreateStatement卡死
- ORDER BY 的问题请帮忙
- 求一SQL语句~~~
before insert on test
for each row
declare ID number(10);
begin
select seq_test.nextval into ID from dual;
select ID,ID,ID into :new.id1,new.id2,new.id3 from dual;
end tri_test;
Create or replace trigger "tri_test"
before insert on test
for each row
declare ID number(10);
begin
select seq_test.nextval into ID from dual;
select ID,ID,ID into :new.id1,:new.id2,:new.id3 from dual;
end tri_test;
DECLARE
id nember;
begin
select seq_test.nextval into id from dual;
:new.id1:=id;
:new.id2:=id;
:new.id3:=id;
end;