//for each row; 这没';'吧
create trigger user_seq_inc
after insert on Users for each row is
declare info number(10);
begin
select user_seq.nextval into a from dual;
end user_seq_inc;
create trigger user_seq_inc
after insert on Users for each row is
declare info number(10);
begin
select user_seq.nextval into a from dual;
end user_seq_inc;
不会是要我在java里面用sqlj写吧
after insert on Users for each row
declare
info number(10);
begin
select user_seq.nextval into info from dual;
end user_seq_inc;
如果真的不行的话,只能改用其他方法来触发了。
after insert on Users for each row;begin
select user_seq.nextval into :new.字段名 from dual;
end user_seq_inc;