Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --EJERCICIOS TRIGGERS
- -- 1. Impedir borrar empleados del departamento 20
- -- 2. Impedir subidas salarios de mas del 20% con formato num_empleado antes despues fecha.
- CREATE OR REPLACE TRIGGER borrar_emple
- BEFORE DELETE ON EMPLE
- FOR EACH ROW
- BEGIN
- IF :old.dept_no = 10 THEN
- RAISE_APPLICATION_ERROR(-20001,'No se puede borrar la fila');
- END IF;
- END;
- /
- CREATE TABLE subidas_salario
- CREATE OR REPLACE TRIGGER subsal
- BEFORE UPDATE ON EMPLE
- FOR EACH ROW
- BEGIN
- IF :NEW.salario > (:old.salario + (0.2*:old.salario)) THEN
- RAISE_APPLICATION_ERROR (-20001,'La subida supera el 20%');
- END IF;
- INSERT INTO subidas_salarios VALUES (:old.emp_no || '*' || :old.salario || '*' || :NEW.salario || '*' || SYSDATE);
- END;
- /
Add Comment
Please, Sign In to add comment