Untitled

BEGIN

DBMS_OUTPUT.PUT_LINE('Sailors who have reserved boats after May 4, 2006:');
DBMS_OUTPUT.PUT_LINE('Name' || '  ' || 'Reservation Date');

FOR sailors_row IN (
        SELECT sname, day
        FROM reserves r, sailors s
        WHERE (day - TO_DATE('04-MAY-06') > 0) AND
        r.sid = s.sid;
	)
LOOP
        DBMS_OUTPUT.PUT_LINE(sailors_row.sname || '  ' || sailors_row.day);
END LOOP;
END;
/