EXERCISE

SET SERVEROUTPUT ON;
DECLARE
  actualDate DATE;
  reservationDate DATE := TO_DATE('25.02.2012', 'dd.mm.yyyy');
  canceledDate DATE;
BEGIN
  SELECT SYSDATE INTO actualDate FROM DUAL;
  DBMS_OUTPUT.PUT_LINE('ACTUAL DATE: ' || actualDate || ' RESERVATION DATE: ' || reservationDate);
  DBMS_OUTPUT.PUT_LINE('ActualDate - ReservationDate: ' || ROUND((actualDate - reservationDate), 2));
  IF (actualDate - reservationDate) >=2 THEN
    canceledDate := actualDate;
    DBMS_OUTPUT.PUT_LINE('CANCELED DATE: ' || canceledDate);
  ELSE
    DBMS_OUTPUT.PUT_LINE('Rezervacia prebehla uspesne');
  END IF;
END;