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
--q1: 
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;
 
 
--q2:
FOR emp_rec IN (SELECT ENAME, SAL FROM EMP WHERE SAL > 2000) LOOP
v_emp_name:= emp_rec.ENAME;
v_annual_salary:= emp_rec.SAL*12; 
 
DBMS_OUTPUT.PUT_LINE('Employee Name Is: ' || v_emp_name || ' His Annual Salary= ' || v_annual_salary);
END LOOP;
END;
/

REVDTEFSRQp2X2VtcF9oaXJlZGF0ZSBFTVAuSElSRURBVEUlVFlQRTsKdl9tZ3JfaGlyZWRhdGUgRU1QLkhJUkVEQVRFJVRZUEU7CnZfZW1wX25hbWUgRU1QLkVOQU1FJVRZUEU7CnZfYW5udWFsX3NhbGFyeSBFTVAuU0FMJVRZUEU7CgpCRUdJTgotLXExOiAKU0VMRUNUIEhJUkVEQVRFIElOVE8gdl9lbXBfaGlyZWRhdGUgRlJPTSBFTVAgV0hFUkUgRU1QTk8gPSA3Nzg4OwpTRUxFQ1QgSElSRURBVEUgSU5UTyB2X21ncl9oaXJlZGF0ZSBGUk9NIEVNUCBXSEVSRSBFTVBOTyA9IDc1NjY7CgpEQk1TX09VVFBVVC5QVVRfTElORSgnU0NPVFQgaGlyZWQgaW4gJyB8fCBUT19DSEFSKHZfZW1wX2hpcmVkYXRlLCAnREQvTU0vWVlZWScpIHx8ICcgYW5kIGhpcyBtYW5hZ2VyIGhpcmVkIGluICcgfHwgVE9fQ0hBUih2X21ncl9oaXJlZGF0ZSwgJ0REL01NL1lZWVknKSk7CgpJRiB2X2VtcF9oaXJlZGF0ZSA+IHZfbWdyX2hpcmVkYXRlIFRIRU4KREJNU19PVVRQVVQuUFVUX0xJTkUoJ0hlIGlzIGhpcmVkIGFmdGVyIGhpcyBtYW5hZ2VyJyk7CgpFTFNJRiB2X2VtcF9oaXJlZGF0ZSA8IHZfbWdyX2hpcmVkYXRlIFRIRU4KREJNU19PVVRQVVQuUFVUX0xJTkUoJ0hlIGlzIGhpcmVkIGJlZm9yZSBoaXMgbWFuYWdlcicpOwpFTFNFCkRCTVNfT1VUUFVULlBVVF9MSU5FKCdCb3RoIGhpcmVkIG9uIHRoZSBzYW1lIGRhdGUnKTsKRU5EIElGOwoKCi0tcTI6CkZPUiBlbXBfcmVjIElOIChTRUxFQ1QgRU5BTUUsIFNBTCBGUk9NIEVNUCBXSEVSRSBTQUwgPiAyMDAwKSBMT09QCnZfZW1wX25hbWU6PSBlbXBfcmVjLkVOQU1FOwp2X2FubnVhbF9zYWxhcnk6PSBlbXBfcmVjLlNBTCoxMjsgCgpEQk1TX09VVFBVVC5QVVRfTElORSgnRW1wbG95ZWUgTmFtZSBJczogJyB8fCB2X2VtcF9uYW1lIHx8ICcgSGlzIEFubnVhbCBTYWxhcnk9ICcgfHwgdl9hbm51YWxfc2FsYXJ5KTsKRU5EIExPT1A7CkVORDsKLw==