-
Hi,
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.
Thanks
[Edited by mber on 03-27-2001 at 11:29 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|