DECLARE
v_emp_hiredate EMP.HIREDATE%TYPE;
v_mgr_hiredate EMP.HIREDATE%TYPE;
v_emp_name EMP.ENAME%TYPE;
v_annual_salary EMP.SAL%TYPE;
 
BEGIN
 
SELECT HIREDATE INTO v_emp_hiredate FROM EMP WHERE EMPNO = 7788;
SELECT HIREDATE INTO v_mgr_hiredate FROM EMP WHERE EMPNO = 7566;
 
DBMS_OUTPUT.PUT_LINE('SCOTT hired in ' || TO_CHAR(v_emp_hiredate, 'DD/MM/YYYY') || ' and his manager hired in ' || TO_CHAR(v_mgr_hiredate, 'DD/MM/YYYY'));
 
IF v_emp_hiredate > v_mgr_hiredate THEN
DBMS_OUTPUT.PUT_LINE('He is hired after his manager');
 
ELSIF v_emp_hiredate < v_mgr_hiredate THEN
DBMS_OUTPUT.PUT_LINE('He is hired before his manager');
ELSE
DBMS_OUTPUT.PUT_LINE('Both hired on the same date');
END IF;

REVDTEFSRQp2X2VtcF9oaXJlZGF0ZSBFTVAuSElSRURBVEUlVFlQRTsKdl9tZ3JfaGlyZWRhdGUgRU1QLkhJUkVEQVRFJVRZUEU7CnZfZW1wX25hbWUgRU1QLkVOQU1FJVRZUEU7CnZfYW5udWFsX3NhbGFyeSBFTVAuU0FMJVRZUEU7CgpCRUdJTgoKU0VMRUNUIEhJUkVEQVRFIElOVE8gdl9lbXBfaGlyZWRhdGUgRlJPTSBFTVAgV0hFUkUgRU1QTk8gPSA3Nzg4OwpTRUxFQ1QgSElSRURBVEUgSU5UTyB2X21ncl9oaXJlZGF0ZSBGUk9NIEVNUCBXSEVSRSBFTVBOTyA9IDc1NjY7CgpEQk1TX09VVFBVVC5QVVRfTElORSgnU0NPVFQgaGlyZWQgaW4gJyB8fCBUT19DSEFSKHZfZW1wX2hpcmVkYXRlLCAnREQvTU0vWVlZWScpIHx8ICcgYW5kIGhpcyBtYW5hZ2VyIGhpcmVkIGluICcgfHwgVE9fQ0hBUih2X21ncl9oaXJlZGF0ZSwgJ0REL01NL1lZWVknKSk7CgpJRiB2X2VtcF9oaXJlZGF0ZSA+IHZfbWdyX2hpcmVkYXRlIFRIRU4KREJNU19PVVRQVVQuUFVUX0xJTkUoJ0hlIGlzIGhpcmVkIGFmdGVyIGhpcyBtYW5hZ2VyJyk7CgpFTFNJRiB2X2VtcF9oaXJlZGF0ZSA8IHZfbWdyX2hpcmVkYXRlIFRIRU4KREJNU19PVVRQVVQuUFVUX0xJTkUoJ0hlIGlzIGhpcmVkIGJlZm9yZSBoaXMgbWFuYWdlcicpOwpFTFNFCkRCTVNfT1VUUFVULlBVVF9MSU5FKCdCb3RoIGhpcmVkIG9uIHRoZSBzYW1lIGRhdGUnKTsKRU5EIElGOw==