I have two tables: table1 and table2, and i want to create a trigger like:
create or replace trigger trig_1
after insert on table1
update table2 set col1 = ....(based on sum(col2 of table1))
Within this trigger i want to update table2. This update is based on column1 in table1(basically on summation of column1 for table1), if i do "select sum(col1) from table1" ---- they must be mutating, please help.
BTW, there is not foreign key relationship and the col1 in table2, col2 in table1 are not keys in both tables.
[Edited by mber on 03-27-2001 at 11:29 PM]
Click Here to Expand Forum to Full Width