若有主键可以这样; select * from tabname id in (select last_value(id) over(order by rownum) from tabname);
insert into table2 (a,b,c) values (:new.a,:new.b,:new.c)
CREATE OR REPLACE TRIGGER A_INS AFTER INSERT ON A FOR EACH ROW --逐行触发 BEGIN INSERT INTO B(A1,A2,A3) VALUES(:NEW.A1,:NEW.A2,:NEW.A3 ); EXCEPTION --判断是否出错 WHEN OTHERS THEN RAISE; END A_INS; /
select * from tabname id in (select last_value(id) over(order by rownum) from tabname);
AFTER INSERT ON A
FOR EACH ROW --逐行触发
BEGIN
INSERT INTO B(A1,A2,A3)
VALUES(:NEW.A1,:NEW.A2,:NEW.A3 );
EXCEPTION --判断是否出错
WHEN OTHERS THEN
RAISE;
END A_INS;
/