SIMULACIA

SET SERVEROUTPUT ON
DECLARE
actualDate DATE;
reservationDate DATE;
canceledDate DATE;

BEGIN
reservationDate := TO_DATE ('25.02.12');
SELECT SYSDATE INTO actualDate FROM dual;
DBMS_OUTPUT.put_line('---------------------------');
DBMS_OUTPUT.put_line('ACTUAL DATE: ' || actualDate || ' RESERVATION_DATE: ' || reservationDate);
DBMS_OUTPUT.put_line('---------------------------');
IF ((actualDate - reservationDate) >= 2) THEN
  canceledDate := actualDate;
  DBMS_OUTPUT.put_line('RESERVATION CANCELED');
  DBMS_OUTPUT.put_line('CANCELED DATE: ' || canceledDate);
  DBMS_OUTPUT.put_line('---------------------------');
END IF;
END;