Question

对于yggl数据库，表a与表b的列employeeid应满足参照完整性规则，用触发器实现两表参照完整性 谢谢回答

Answer 1

CREATE OR REPLACE TRIGGER dept_cascade2
AFTER DELETE OR UPDATE OF deptno ON dept
FOR EACH ROW
BEGIN
IF UPDATING THEN
UPDATE emp SET deptno=:new.deptno,
update_id=integritypackage.updateseq
WHERE emp.deptno=:old.deptno AND update_id IS NULL;
END IF;
IF DELETING THEN
DELETE FROM emp
WHERE emp.deptno=:old.deptno;
END IF;
END;

-----------------------------------------------------------------------------------
CREATE OR REPLACE TRIGGER tr_emp
AFTER UPDATE OF employeeid
ON a
FOR EACH ROW
DECLARE v_count NUMBER;
BEGIN
SELECT COUNT(*) INTO v_count
FROM a WHERE employeeid =: new.employeeid;
IF v_count = 0 THEN
INSERT INTO b(employeeid)
VALUES(:new.employeeid);
ELSE
UPDATE b SET employeeid =: new.employeeid
WHERE a.XX=b.XX
END IF;
END;

你参考这两个存储过程，就能解决了。。。不懂再问吧