mutating problem solution using compound triggers
i am using 11g.
i am updating one column in a table.based on that value i want to insert one row in same table.
i want to use trigger.it will cause mutating.using compound trigger how to solve that one.
i am writting trigger on test table.
create or replace trigger trig1
before update of result on test
for each row....
how to create compound trigger to solve this one.