DAIS_1

ALTER TABLE "User" ADD (maxActiveReservationCount INT);

CREATE OR REPLACE
FUNCTION getReservationCount (
                  p_idUser "User".iduser%TYPE
                  ) RETURN INT AS

reservationCounter INT;
BEGIN
SELECT COUNT(*) INTO reservationCounter FROM Reservation WHERE iduser = p_iduser;
RETURN reservationCounter;
END;

SET SERVEROUTPUT ON
DECLARE
output VARCHAR2(10);
BEGIN
output:= getReservationCount(5);
DBMS_OUTPUT.PUT_LINE('NUMBER OF RESERVATIONS: '|| output);
END;