What have I got so far: CREATE OR REPLACE PROCEDURE P_Emprestimo (idE INT)IS BEGIN update Emprestimo set dataPrevistaDevolucao = dataPrevistaDevoluçao + 7 where id = idE; END; When he returns to me:…
I have the following table: CREATE TABLE Emprestimo ( id int PRIMARY KEY, dataRetirada date DEFAULT current_date, dataPrevistaDevolucao date DEFAULT current_date + 7, dataDevolucao date,…