I have a table in which there are fields like Quantity, Price, Total etc.There's is also a primary key field in this table.
We have an interface where user can change the quantity (only quantity).
I want to write a trigger on this table which calculates Total (qty * price) whenever qantity is updated.
How can I do it..?. How will I know for which row the quantity is updated..?
Thanks in advance..