CREATE OR REPLACE TRIGGER t_pret
before INSERT OR UPDATE OF pret ON rand_comenzi
FOR each ROW
DECLARE
    v_pret_lista NUMBER;
    v_id_produs NUMBER;
BEGIN

    SELECT id_produs INTO v_id_produs FROM produse WHERE id_produs=:NEW.id_produs;
    v_pret_lista:=n2(v_id_produs);
      :NEW.pret:=v_pret_lista;

END;
/
UPDATE rand_comenzi
SET pret=4 WHERE nr_comanda=2392 AND id_produs=3124;
ROLLBACK;

SELECT* FROM rand_comenzi;
SELECT*FROM produse WHERE id_produs=3124;