create or replace trigger aa
on A before insert
for each row
declare
v_n number;
begin
select count(1) into v_n
from dual
where exists
(select 1 from b where xh=:new.xh)
if v_n > 0 then
update b set sl=sl+:new.sl;
else
insert into b values(:new.xh,:new.sl)
end if;
end;
on A before insert
for each row
declare
v_n number;
begin
select count(1) into v_n
from dual
where exists
(select 1 from b where xh=:new.xh)
if v_n > 0 then
update b set sl=sl+:new.sl;
else
insert into b values(:new.xh,:new.sl)
end if;
end;
解决方案 »
- 记事本里的数据导入oracle数据库------------------标题要长-----------------
- oracle text 创建索引报 ora:04030错误!
- sql
- primary 与 unique 有什么分别呢?
- 写一个job每天晚上1:00 钟执行一个存储过程?
- 请教OracleOraHome81ManagementServer 总是启动失败问题?
- 帮忙写条sql语句!
- 数据库备份初级问题
- delphi中访问oracle数据库,不安装oracle client,要怎么做?
- 我在存储过程中的字符串 '这么表示?
- Installshield developer8 + Oracle数据库,制作安装程序
- 简单但是富有挑战!
before insert on a
for each row
begin
update b set SL=SL+1 where XH=:new.XH;
if sql%rowcount=0 then
insert b values(:new.sl,:new.xh);
end if;
end;
/