触发器程序:
create or replace trigger TR1
after insert on b2
for each row
declare last_insert_jh VARCHAR(11)
begin
insert into b2(jh)
select b2.jh from b2 where b2.jh=last_insert_jh;
end ;帮忙看看有什么问题?
create or replace trigger TR1
after insert on b2
for each row
declare last_insert_jh VARCHAR(11)
begin
insert into b2(jh)
select b2.jh from b2 where b2.jh=last_insert_jh;
end ;帮忙看看有什么问题?
create or replace trigger TR1
BEFORE insert on b2
for each row begin
insert into b2(jh) VALUES(:OLD.JH);
COMMIT;
end ;
before insert on b2
for each row
begin
insert into a1 (jh) values (:new.jh);
end;
create or replace trigger TR1
BEFORE insert on b2
for each row begin
insert into a1 (jh) VALUES(:OLD.JH);
COMMIT;
end ;
这样就好
create or replace trigger TR1
before insert on b2
for each row
begin
insert into a1 (jh) values (:new.jh);
end;
应该用After吧,commit也应该有吧。