CREATE OR REPLACE TRIGGER I PD_TEAM_SALARY
AFTER INSERT OR UPDATE OR DELETE ON PLAYER
FOR EACH ROW
BEGIN
UPDATE TEAM
SET TOT_SALARY=TOT_SALARY+:NEW SALARY.
WHERE ID=:NEW:TEAM_ID;
You will be adding additional coat later but for now you want the current block to fire when updated the salary column. Which solution should you use to verify that the user is performing an update on the salary column?
A. ROWUPDATEC SALARY')
B. UPDATING('SALARY')
C. CHANGING('SALARY')
D. COLUMN_UPDATE(' SALARY')
Answer: B