Thanks for your help Jonathan.
Do triggers set off other triggers recursively?
Using the Sql for Smarties example, if I have parts A, B, C, D, and E, and some of the parts are composed of other parts like so:
A
/
B C
/
D E
So part A is composed of part B and C, and part C is composed of D and E.
Let's say I have a trigger on the PARTS table which updates the parent parts' weight.
If I update D's weight and add 5 kilos to it, then part C and A should also go up 5 kilos. Would a trigger on the PARTS table which updated the parent part fire twice? Would it hang if there were loops? The Oracle8: The Complete Reference book doesn't seem to have any information on this that I can find.
