CREATE OR REPLACE TRIGGER TRIGGER_YSC_HUIZONGBAOBIAO
AFTER INSERT OR UPDATE OR DELETE
of co_code,account_id,fiscal,fis_perd,acc_code,fis_,dr_amt,cr_amt
ON GL_BAL
FOR EACH ROW
when (new.co_code<>'C000002' or account_id<>'10')
BEGIN
DELETE FROM GL_BAL WHERE ACCOUNT_ID='10' AND CO_CODE='C000002' and fis_perd= :new.fis_perd and fiscal= :new.fisperd;
INSERT INTO GL_BAL
SELECT * FROM YSC_HZBB where fis_perd= :new.fis_perd and fiscal= :new.fisperd;
END;刚刚接触触发器,我写的这个触发器提示我new不对,高手帮我看看怎么样才能用变化的内容里的字段呢?
AFTER INSERT OR UPDATE OR DELETE
of co_code,account_id,fiscal,fis_perd,acc_code,fis_,dr_amt,cr_amt
ON GL_BAL
FOR EACH ROW
when (new.co_code<>'C000002' or account_id<>'10')
BEGIN
DELETE FROM GL_BAL WHERE ACCOUNT_ID='10' AND CO_CODE='C000002' and fis_perd= :new.fis_perd and fiscal= :new.fisperd;
INSERT INTO GL_BAL
SELECT * FROM YSC_HZBB where fis_perd= :new.fis_perd and fiscal= :new.fisperd;
END;刚刚接触触发器,我写的这个触发器提示我new不对,高手帮我看看怎么样才能用变化的内容里的字段呢?
解决方案 »
- ORACLE VPD 策略函数返回结果中如何给别名
- Oracle初学者!关于sql plus的问题
- 请问下面的SQL语句为什么执行很慢?
- 请高手帮忙看个Oracle权限的问题!谢谢!
- 如何查看oracle里面试图 view1 存不存在,如果存在就删除
- SQL> sqlldr userid=system/manager@ mingal control=input.ctl这错在哪?
- 如何按时将实时表的数据备份到备份表?
- 向各位高手请教一个复杂的sql查询问题。
- 关于几个sql内置函数的问题
- 求助oracle创建表空间时遇到ora00972 : 标识符过长
- 唉!!怎么就安装不上oracle呢!!
- 急急急急急急!!!!!!!!!!!!希望各位大哥赶快帮忙做一下,谢谢了 小弟急着用.!!!!!!!!!!!在线等待...
AFTER INSERT OR UPDATE OR DELETE
of co_code,account_id,fiscal,fis_perd,acc_code,fis_,dr_amt,cr_amt
ON GL_BAL
FOR EACH ROW
BEGIN
when (:new.co_code <> 'C000002 ' or :new.account_id <> '10 ') then
DELETE FROM GL_BAL WHERE ACCOUNT_ID= '10 ' AND CO_CODE= 'C000002 ' and fis_perd= :new.fis_perd and fiscal= :new.fisperd;
INSERT INTO GL_BAL
SELECT * FROM YSC_HZBB where fis_perd= :new.fis_perd and fiscal= :new.fisperd;
END;