create or replace procedure insert_abc( p_id in integer, p_val1 in varchar2, p_val2 in varchar2 ) as begin insert into c select id,name,age from b where id=p_id; if sql%rowcount=0 then insert into a values(p_id,p_val1,p_val2); end if; commit; end ; /
p_id in integer,
p_val1 in varchar2,
p_val2 in varchar2
)
as
begin
insert into c select id,name,age from b where id=p_id;
if sql%rowcount=0 then
insert into a values(p_id,p_val1,p_val2);
end if;
commit;
end ;
/
如果要在后台实现,就要用到触发器了。