Pregunta2.sql

CREATE OR REPLACE TRIGGER aud_sailors
AFTER UPDATE ON SAILORS
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
BEGIN
	INSERT INTO AUD_SAILORS
	VALUES (
			USER,
			SYSDATE,
			:OLD.RATING,
			:OLD.AGE,
			:NEW.RATING,
			:NEW.AGE,
		)
END;
/

connect sys/admin as sysdba;
grant update on sailors.sailors to hr;
/

connect hr/hr;
UPDATE SAILORS.Sailors set rating=2 WHERE sid=22;
UPDATE SAILORS.Sailors set rating=2, age= 35 WHERE sid=29;
UPDATE SAILORS.Sailors set age=2, age= 35 WHERE sid=71
COMMIT;
/

connect sailors/sailors;
SELECT * FROM SAILORS.AUD_SAILORS;
/*
USUARIO                        AUD_FECH OLD_RATING    OLD_AGE NEW_RATING
------------------------------ -------- ---------- ---------- ----------
   NEW_AGE
----------
HR                             27/11/14          1         33          2
        35

HR                             27/11/14         10         16          2
        35

HR                             27/11/14          2         45          2
        45
*/
/