CREATE OR REPLACE TRIGGER Saku
 AFTER UPDATE
ON Shtat_R FOR EACH ROW
DECLARE
CURSOR c IS SELECT salary, SRno FROM Shtat_R WHERE SRno=3;
UPDATE hist
SET salary=c.salary
WHERE SR_no=c.SRno;
UPDATE hist
SET data=SYSDATE
WHERE SR_no=c.SRno;
COMMIT;
/

UPDATE Shtat_R
SET salary=1250000
WHERE SRno=3;