on commit fire triggers
Dear Friends,
I want to update the amount of the master table with the sum of all transaction records which consists of hundreds of records per a session.
I have create a temporary table, and at the point of the commit i wants to update the master table at once..
could i write a trigger for tempory table to fire on commit.
regrds
upul Indika.