所以我有这两个表:
创建表CURRENCY( 名称VARCHAR2(40 CHAR)PRIMARY KEY, 值NUMBER(6,2));
创建表EXCHANGE_RATE( currency1引用CURRENCY(name), …
您无法查询导致触发器在触发器内部触发的表。
如果我是你,我会考虑使用存储过程方法。只需将插入脚本移动到过程中即可
CREATE PROCEDURE INS_CURRENCY (p_currency varchar2, p_price number) as BEGIN INSERT INTO CURRENCY VALUES(p_currency , p_Price); INSERT INTO EXCHANGE_RATE (currency1, currency2, price) SELECT name, p_currency, price/p_price FROM CURRENCY WHERE NAME != p_current; INSERT INTO EXCHANGE_RATE (currency1, currency2, price) SELECT p_currency, name, p_price/price FROM CURRENCY WHERE name != p_currency; END;