triggers

-- TRIGGERS

-- 4

CREATE TABLE EMPLEADO (
    ID      INTEGER,
    NOMBRE   VARCHAR2(100)
);



CREATE OR REPLACE TRIGGER t_empleados BEFORE
    INSERT ON employees
    FOR EACH ROW
BEGIN
    INSERT INTO EMPLEADO VALUES (
        :NEW.employee_id,
        :NEW.first_name,
    );
END;


INSERT INTO employee (id, name, dept, age, salary location) VALUES (10000001, 'Srinath', 'Aeronautics', 27, 33000);


SELECT * FROM EMPLEADO;






-- 5

CREATE TABLE mis_departamentos
  AS (SELECT * FROM DEPARTMENTS);



CREATE TABLE hist_departamentos (
    ID      INTEGER,
    NOMBRE   VARCHAR2(100)
);


CREATE OR REPLACE TRIGGER t_depart BEFORE
    UPDATE OF department_name ON mis_departamentos
    FOR EACH ROW
    WHEN department_id = 90
BEGIN
    INSERT INTO hist_departamentos VALUES (
        :old.department_id,
        :old.department_name
    );
END;


UPDATE mis_departamentos SET department_name = ('pruebaDepartamento') WHERE department_id = 90;


SELECT * FROM hist_departamentos;