--2
CREATE OR REPLACE PROCEDURE istoric_job (id_ang IN istoric_functii.id_angajat%TYPE,
id_job IN istoric_functii.id_functie%TYPE) IS
id angajati.id_angajat%TYPE;
data_start angajati.data_angajare%TYPE;
BEGIN
INSERT INTO istoric_functii
SELECT id_angajat,data_angajare,SYSDATE,id_functie,id_departament
FROM angajati WHERE id_angajat = id_ang;
UPDATE angajati SET
data_angajare = SYSDATE, id_functie = id_job, salariul=(SELECT salariu_min FROM functii WHERE id_functie = id_job)
WHERE id_angajat = id_ang;
END;
/
BEGIN
istoric_job(106,'SY_ANAL');
END;
/
SELECT * FROM angajati WHERE id_angajat = 106;
SELECT * FROM istoric_functii WHERE id_angajat = 106;